i’m working now with hadoop and sap hana for around 3 month and i stick heavily.
My Hadoop System is importing and converting logfiles via pig script and generates a result, which i finally want to export to sap hana appliance.
I wanted to use sqoop for this task, but at the moment, i’m wondering about the error message and the behavior of the system.
To get handy with sqoop, i generated a test file with some simple input like this:
On the other side, i generated a table in sap hana with a text field column.
I used this sqoop command to successfully export the hdfs test file into sap hana:
sqoop export –connect jdbc:sap://saphana.XXX.XXX:30115/ –driver com.sap.db.jdbc.Driver –table XXX.XXX–username XXX –password XXX –export-dir /user/tom/test
And it worked. I saw 1 3 and 5 on the sap hana side.
Then i tried to export much more data, but till in the simple format like:
And then i got some error messages, which dont have something to do with the change of my test file:
15:18:44 INFO – org.apache.hadoop.mapred.JobClient.monitorAndPrintJob(1422) | Task Id : attempt_201312180839_0052_m_000000_0, Status : FAILED
java.io.IOException: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: : sql syntax error: incorrect syntax near “,”: line 1 col 35 (at pos 35)
Could someone help me with this dirty problem?