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.?
0
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
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]