Please provide the valuable suggestion for SQOOP-SAP Connectivity. Discussion and log as below
---------- Forwarded message ---------- From: Ravi Sharma <[email protected]> Date: Thu, Dec 26, 2013 at 3:46 PM Subject: Re: SAP Connector? To: [email protected] What i find more is sqoop expecting only table name but I'm providing the Schema_name.table_name. Command is as follow: sqoop import --connect jdbc:sap://dns:30015 --driver com.sap.db.jdbc.Driver --username USER_NAME --password PASSSWORD --table /SCHEMA_NAME.TABLE_NAME --target-dir OUTPUT Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ".": line 1 col 116 (at pos 116) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:334) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:174) at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:104) at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1111) at com.sap.db.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1941) at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:972) at com.sap.db.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:233) at com.sap.db.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:192) at com.sap.db.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:103) at com.sap.db.jdbc.CallableStatementSapDBFinalize.<init>(CallableStatementSapDBFinalize.java:31) at com.sap.db.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:1351) at com.sap.db.jdbc.trace.Connection.prepareStatement(Connection.java:347) at org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:101) at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:237) ... 12 more And if I don't provide the schema name then it's shows 1 ERROR manager.SqlManager: Error executing statement: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name: Could not find table/view TABLE_NAME in schema USER_NAME: line 1 col 17 (at pos 16) com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name: Could not find table/view TABLE_NAME in schema USER_NAME: line 1 col 17 (at pos 16) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:334) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:174) at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:104) at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1111) at com.sap.db.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1941) at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:972) Is error related to passing the schema definition? My command is as follow sqoop import --connect jdbc:sap://dns:30015/SCHEMA_NAME --driver com.sap.db.jdbc.Driver --username USER_NAME --password PASSSWORD --table TABLE_NAME --target-dir OUTPUT Cheers, Ravi Sharma On Thu, Dec 26, 2013 at 3:42 PM, Jarek Jarcec Cecho <[email protected]>wrote: > Would you mind sharing used Sqoop command line and entire log generated > with parameter --verbose, so that we can take a look into failures that you > are experiencing? > > Jarcec > > On Thu, Dec 26, 2013 at 03:41:23PM +0530, Ravi Sharma wrote: > > Does it possible to make SAP connection with sqoop? > > > > > > Simple SAP JDBC jar is not able to perform the Sqoop job. > > > > Any Suggestion > > > > > > Cheers, > > Ravi Sharma > > > > -- > > > > --- > > You received this message because you are subscribed to the Google > Groups "CDH Users" group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected]. > > For more options, visit > https://groups.google.com/a/cloudera.org/groups/opt_out. >
