Has anyone seen this before and even better doe anyone know how we can use the Vertica CUBE function
We use “Vertica Analytic Database v7.1.1-0”
I started vsql on the linux databaseserver to be sure the client tool is not the reason of failure.:
When I execute the following statement:
vertica=> select grantor, object_type, count(1), grouping_id()
vertica-> from grants
vertica-> group by CUBE (grantor, object_type);
I got the following error:
ERROR 3457: Function CUBE(varchar, varchar) does not exist, or permission is denied for CUBE(varchar, varchar)
HINT: No function matches the given name and argument types. You may need to add explicit type casts
Vertica user has root permisions.
When I replace CUBE with ROLLUP everything is working perfectly
select grantor, object_type, count(1), grouping_id()
from grants
group by ROLLUP (grantor, object_type)
grantor | object_type | count | grouping_id
-------------------------+--------------+-------+-------------
vertica | RESOURCEPOOL | 23 | 0
vertica | PROCEDURE | 92 | 0
vertica | | 152 | 1
lijn_user | | 4 | 1
pentaho_operations_mart | TABLE | 66 | 0
lijn_user | SCHEMA | 4 | 0
| | 1113 | 3
vertica | SCHEMA | 8 | 0
etl_user | | 882 | 1
vertica | ROLE | 29 | 0
ml | | 6 | 1
etl_user | TABLE | 875 | 0
pentaho_operations_mart | SCHEMA | 3 | 0
etl_user | SCHEMA | 7 | 0
pentaho_operations_mart | | 69 | 1
ml | SCHEMA | 6 | 0
(16 rows)
We are just starting doing the Vertica DBA tasks and this is the first issue we have to solve.
I whould by happy with any suggstion to solve this problem,
Regards,
Tom Kooi
ONVZ Health ensurance
The Netherlands
