The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
COPY FROM LOCAL PARQUET ?
Does anyone know if it's possible to copy parquet files from local ?
I tried this but got syntax errors
COPY sometable FROM LOCAL 'someparquetfile' PARQUET;
Thanks
Dave
Tagged:
0
Best Answer
-
Jim_Knicely Administrator
No, you can not use COPY LOCAL with the PARQUET parser. But you can use ON NODE...
See:
COPY LOCAL0
Answers
Thanks for your reply
That's a pity as I have no access to the production database servers.
Customer is moving away from Hadoop and hasn't got AWS or Google storage either so I can't create locations there for the parquet files.
Seems odd that clients can't load parquet, I hope it gets added
Regards
Dave
You can load Parquet files from HDFS!
See:
COPY Examples
Creating External Tables with ORC or Parquet Data