Skip to Content
-1

Cannot open CSV file SAP HANA import

Aug 30, 2017 at 12:05 PM

172

avatar image
Former Member
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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Nov 18, 2017 at 05:28 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded