The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Vertical Copy command from ORC

AnilBAnilB
in General Discussion

Hi,

 

I am trying to load ORC file to vertica using copy command. I have few queries regarding ORC copy.

1. Is it possible to load sub set of columns from ORC to vertica? When I check, it's failing with number of column mismatch.

2. Is there any way to provide schema to copy command so that we can only prune few columns? like KafkaSource.

 

Thanks,

B Anil Kumar.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
Heading 1Heading 2
QuoteCodeSpoiler
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 ...

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