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;
No, you can not use COPY LOCAL with the PARQUET parser. But you can use ON NODE...
See: COPY LOCAL
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
You can load Parquet files from HDFS!
See:COPY ExamplesCreating External Tables with ORC or Parquet Data
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.