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

  • [Deleted User][Deleted User] 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