Hi Forum,
I am supporting a prospect in a Vertica POC. They are wanting to make EXPORT TO PARQUET available for all database users (not only dbadmin) but getting errors (see below text from an email).
Can you please share the statements required for this? I could not figure this on my own.
I see library ParquetExportLib containing 3 functions. So I need one grant for the library and three for each of the functions?
Can you please reply with the exact SQL, I could not get this working.
Thank you
Email from the prospect:
Hi Dieter,
We encountered another problem that we still were not able to solve:
The EXPORT TO PARQUET function seems to works only as dbadmin on the local filesystem for us:
dbadmin=> export to parquet(directory='/tmp/proc3') as select * from testuser00.proc3;
Rows Exported
9
If we try to use the function as a regular user we get the following error message:
testuser00=> EXPORT TO PARQUET(directory='/tmp/proc3') AS SELECT * from proc3;
ERROR 3457: Function ParquetExportFinalize(int) does not exist, or permission is denied for ParquetExportFinalize(int)
HINT: No function matches the given name and argument types. You may need to add explicit type casts
The same holds for using a hdfs path as well as a custom USER storage location.
The documentation (https://my.vertica.com/docs/8.1.x/HTML/#Authoring/SQLReferenceManual/Statements/EXPORTTOPARQUET.htm) mentions no special needed Privileges.
