Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Copy returns 11380 Null pointer exception

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.

Comments

  • 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??


  • 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.

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.