Copy returns 11380 Null pointer exception

Lee_1

I have seen an intermittent problem when trying to do a COPY operation to upload data. The command that I am issuing is:

COPY mytable FROM LOCAL myfile.csv WITH PARSER public.LibCSVParser() DIRECT

The parser is the standard example CSV parser that Vertica ships. Occasionally I will get the follow result:

>[Error] Script lines: 7-7 --------------------------
 [Vertica][JDBC](11380) Null pointer exception.
 [Executed: 12/20/2013 4:30:09 PM] [Execution: 0ms] 

The data actually is loaded into the table successfully, but because an error is returned my process thinks that it has failed.

Any help is greatly appreciated.

Nimmi_gupta

Try this COPY command and this should work

COPY t1 from '/home/dbadmin/test.csv' delimiter ',' exceptions '/home/dbadmin/lnq.log';


Trying to use the COPY command you have provided and got the ERROR
ERROR 3457:  Function public.libCSVParser() does not exist, or permission is denied for public.libCSVParser()
HINT:  No function matches the given name and argument types. You may need to add explicit type casts

And though to check from where got the COPY command doc??

Lee_1

You got an error because you haven't installed the CSV parser that is referenced. I am just using the standard CSV parser the HP ships.