Skip to main content
Question

COPY FROM LOCAL PARQUET ?

  • May 10, 2021
  • 3 replies
  • 13 views

dave_wood
Forum|alt.badge.img

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

3 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • May 10, 2021

No, you can not use COPY LOCAL with the PARQUET parser. But you can use ON NODE...

See:
COPY LOCAL


dave_wood
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • May 11, 2021

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


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • May 11, 2021

You can load Parquet files from HDFS!

See:
COPY Examples
Creating External Tables with ORC or Parquet Data