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.?
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 ..
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.