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

Vertica copy

i have 3 attributes in my source file and table is having 4 attributes and i want to default 3rd attribute with default values and other 3 from source file. will vertica copy allow ? if yes what will be the syntax.?

Comments

  • skamatskamat Administrator

    copy table (c1,c2,c4) from '/tmp/sourcefile.dat' direct; -- I have skipped c3 column from my table .

  • i found the syntax and its working ..
    copy

    ( c1, c2, c3. 'adf'as c4) from 'path' [ arguments]

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.