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.?
Vertica copy
+2copy 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]
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
