Skip to main content

Copy returns 11380 Null pointer exception

  • January 17, 2014
  • 2 replies
  • 13 views
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.

    2 replies

    Nimmi_gupta
    Forum|alt.badge.img
    • Nimmi_gupta
    • Participating Frequently
    • January 22, 2014
    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
    • Lee_1
    • Author
    • New Participant
    • January 24, 2014
    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.
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement