Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Using COPY to load avro data to Vertica table

I am using the below command to load the table 'test_table' in vertica. I am using DBVisualizer to run this satatement.  

 

COPY test_table FROM LOCAL '/Users/jsonencode/Downloads/part-r-00000.avro' PARSER favroparser(flatten_records=true,flatten_maps=true,flatten_arrays=true);

 

Sample row from avro file :

{u'Id': u'0123BHYSI', u'Name': u'eCommerce'}
 
When I execute this command, it runs successfully without any error BUT does not load the table with the data. 
 
Am I missing something? Any help is appreciated. 
 
Json
 

 

Comments

  • I am also facing the same issue . 

    No copy is in progress is the message what i get .

     

    Thanks,

    Priyabrat 

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.