We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


COPY file with pipe in string — Vertica Forum

COPY file with pipe in string

Navin_CNavin_C Vertica Customer
Hello All, I have come across a scenario where we need to load some data in the Vertica table. The data here is in a special format Flat file Code: Select all A|B|C|D|edfg|hi|jk|L|J|R| A|B|C|D|hdjf|ih|gm|L|J|R| Here the data in small letters has 2 pipes in them, which Vertica takes as delimitters, But it is a part of one string in the 5th column of flat file. So that completely is a string which needs to be loaded into single column in Vertica table. I am using the copy command for this, but Vertica gives "Column mismatch error" as interpreted by Vertica. How can I load this data into Vertica in a table with 8 columns.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file