Skip to content

Instantly share code, notes, and snippets.

@ankit-rakha

ankit-rakha/vertica_copy_command

Last active August 29, 2015 14:06
Show Gist options
  • Save ankit-rakha/b90f7e30fd924e1103ff to your computer and use it in GitHub Desktop.
Save ankit-rakha/b90f7e30fd924e1103ff to your computer and use it in GitHub Desktop.
Download ZIP
Vertica COPY command to load data
Raw
vertica_copy_command
A Vertica COPY command to load data into the public.dummyTable table from data file dummyTable.psv, which is delimited with a "|" and all exceptions and rejected records are written into the specified log - dummyTable.exceptions & dummyTable.rejections respectively, and the DIRECT option loads data directly into the ROS.
COPY public.dummyTable FROM '/home/dummyTable/dummyTable.psv' DELIMITER '|' EXCEPTIONS '/home/dummyTable/dummyTable.exceptions' REJECTED DATA '/home/dummyTable/dummyTable.rejections' DIRECT NULL '';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment