Hello All, please i am trying to move data from sqoop into HDFS using sqoop. The database is available in the ZSLT_SHE schema, and the name of the table i am trying to import is ADR6. i will attach a screenshot.
I am using this command to import the table but running into an error.
sqoop import --connect 'jdbc:sap://x.x.x.x:xxxxx/?database=HXE&user=xxxxxxx&password=xxxxxx' --table ZSLT_SH20.ADR20 --driver com.sap.db.jdbc.Driver --hive-import --hive-overwrite --split-by CLIENT -m 1
I get an error that says
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162)
Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ".": line 1 col 205 (at pos 205)
schema.png