The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

COPY and NULL and PAIN

Hey,

I'm trying to figure out how I can craft a query that will pull in values from a CSV file that are stored as "null".

I have a query that looks something like this:

COPY (my,list,of,columns) FROM '/a/local/file' DELIMITER ',' NULL NEED HELP HERE REJECTED DATA '/log/the/rejects' EXCEPTIONS '/log/the/exceptions' ENFORCELENGTH DIRECT NO COMMIT

Note the bit between the asterix ** where I'm not sure how to define that the CSV values for NULL are stored as String literals. When I attempt to run the query, the lines with "null" are stored in the rejects file.

Any help much appreciated!

Comments

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.