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

ERROR 5873 on COPY LOCAL command

We've had problems in our environment trying to load data from a .csv file on a local machine via the vsql client.

dbadmin=> COPY sample_schema.sample_table
dbadmin-> FROM LOCAL 'C:\Users\filePath.csv'
dbadmin-> DELIMITER ',';
ERROR 5783:  Client error: Could not open file [C:\Users\filePath.csv] for reading (in function statFiles() at Bulkload.cpp:312)

Has anyone else had this error? The file exists and is fully accessible on the local machine; is there something extra required to allow vsql to read files from certain paths, etc.?

Comments

  • Hello Kate,

    I have managed to produce the same error on my windows client (I am assuming you are running vsql from windows given the path 'C:\users')

    The quickest and easiest fix is to grant 'everyone' full permission to the file "filePath.csv".

    In windows explorer, right click the file > properties > security, then grant 'Everyone' full access to the file

    On my system, as soon as I remove 'everyone' from the permission of the file, the error is produced.  Even though administrator and the user I am running vsql under have read/execute permission to the file.

    Please let me know if that will also solve your issue.

     

    Regards,

    Han

     

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.