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

Best Answer

  • Jim_KnicelyJim_Knicely Administrator
    edited May 11 Accepted Answer

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

    See:
    COPY LOCAL

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

  • Jim_KnicelyJim_Knicely Administrator

    You can load Parquet files from HDFS!

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.