This article provides information on why export to parquet statement is failing and how to resolve the issue.
Environment:
Vertica Analytic Database 9.3.1-28
Situation:
EXPORT TO PARQUET statement is failing with below error,
ERROR 5861: Error calling getPerInstanceResources() in User Function ParquetExport at [/data/qb_workspaces/jenkins2/ReleaseBuilds/build/udx/supported/ParquetExport/ParquetExport.cpp:334], error code: 0, message: Data Type TimeTz is not supported
Cause:
Its failing since TIMETZ datatype is not supported on export to parquet command.
https://docs.vertica.com/25.1.x/en/sql-reference/statements/export-to-parquet/