Skip to Content
avatar image
-1
Former Member

Cannot open CSV file SAP HANA import

IMPORT FROM CSV FILE 'C:\Users\mypc\IdeaProjects\Loadorcle\new\emp.csv' INTO RIGHTDATA.Employees1 WITH SKIP FIRST 1 ROW RECORD DELIMITED BY '\n' FIELD DELIMITED BY '`'

When i run the above query i get the exception: > Exception in thread "main" > com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [2]: > general error: Cannot open CSV file, > C:\Users\mypc\IdeaProjects\Loadorcle\new\emp.csv

The csv file is in a directory new under the project folder. How can i solve this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 18, 2017 at 05:28 AM

    As usual, before posting the question, you should have searched for existing questions and answers for the same problem.

    Checking the HANA documentation on the IMPORT FROM command would have helped, too.

    You would have found that IMPORT FROM only allows to import data from a folder visible to the HANA server process. Your Windows-user's folder is not visible to the HANA server. And that's why you cannot use this command for importing this data.

    Add comment
    10|10000 characters needed characters exceeded