Options

Using COPY to load avro data to Vertica table

jsonencodejsonencode
in General Discussion

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

  • Options
    priya1cvrpriya1cvr

    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...