Cannot open CSV file SAP HANA import

[former_member508219]

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?

[lbreddemann]

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.