Hi Samir Looks like there is some syntax issue with the sql query generated internally .
Can you try doing a Sqoop import by specifying the query with -query option. Regards Bejoy KS Sent from remote device, Please excuse typos -----Original Message----- From: samir das mohapatra <samir.help...@gmail.com> Date: Thu, 21 Feb 2013 13:58:37 To: <user@hadoop.apache.org> Reply-To: user@hadoop.apache.org Subject: Re: ISSUE :Hadoop with HANA using sqoop Putting whole Logs from Task now ------------------------------ ----------------------- Task Logs: 'attempt_201302202127_0021_m_000000_0' *stdout logs* ------------------------------ *stderr logs* log4j:WARN No appenders could be found for logger (org.apache.hadoop.hdfs. DFSClient). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. ------------------------------ *syslog logs* 2013-02-20 23:10:19,391 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead 2013-02-20 23:10:19,525 WARN org.apache.hadoop.util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable 2013-02-20 23:10:20,262 WARN org.apache.hadoop.conf.Configuration: session.id is deprecated. Instead, use dfs.metrics.session-id 2013-02-20 23:10:20,270 INFO org.apache.hadoop.metrics.jvm.JvmMetrics: Initializing JVM Metrics with processName=MAP, sessionId= 2013-02-20 23:10:20,919 INFO org.apache.hadoop.util.ProcessTree: setsid exited with exit code 0 2013-02-20 23:10:20,955 INFO org.apache.hadoop.mapred.Task: Using ResourceCalculatorPlugin : org.apache.hadoop.util.LinuxResourceCalculatorPlugin@64a7c45e 2013-02-20 23:10:23,134 ERROR org.apache.sqoop.mapreduce.db.DBRecordReader: Top level exception: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ".": line 1 col 46 (at pos 46) 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:103) at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:848) at com.sap.db.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1874) at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:945) at com.sap.db.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:230) at com.sap.db.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:190) at com.sap.db.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:101) at com.sap.db.jdbc.CallableStatementSapDBFinalize.<init>(CallableStatementSapDBFinalize.java:31) at com.sap.db.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:1088) 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:236) at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:458) at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:76) at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:85) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139) at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:645) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:325) at org.apache.hadoop.mapred.Child$4.run(Child.java:268) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:416) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1332) at org.apache.hadoop.mapred.Child.main(Child.java:262) 2013-02-20 23:10:23,688 INFO org.apache.sqoop.mapreduce.AutoProgressMapper: Auto-progress thread is finished. keepGoing=false 2013-02-20 23:10:23,738 INFO org.apache.hadoop.mapred.TaskLogsTruncater: Initializing logs' truncater with mapRetainSize=-1 and reduceRetainSize=-1 2013-02-20 23:10:23,861 ERROR org.apache.hadoop.security.UserGroupInformation: PriviledgedActionException as:hadoop (auth:SIMPLE) cause:java.io.IOException: SQLException in nextKeyValue 2013-02-20 23:10:23,861 WARN org.apache.hadoop.mapred.Child: Error running child java.io.IOException: SQLException in nextKeyValue at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:265) at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:458) at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:76) at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:85) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139) at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:645) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:325) at org.apache.hadoop.mapred.Child$4.run(Child.java:268) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:416) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1332) at org.apache.hadoop.mapred.Child.main(Child.java:262) Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ".": line 1 col 46 (at pos 46) 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:103) at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:848) at com.sap.db.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1874) at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:945) at com.sap.db.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:230) at com.sap.db.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:190) at com.sap.db.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:101) at com.sap.db.jdbc.CallableStatementSapDBFinalize.<init>(CallableStatementSapDBFinalize.java:31) at com.sap.db.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:1088) 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:236) ... 12 more 2013-02-20 23:10:23,906 INFO org.apache.hadoop.mapred.Task: Runnning cleanup for the task On Thu, Feb 21, 2013 at 12:03 PM, Harsh J <ha...@cloudera.com> wrote: > The error is truncated, check the actual failed task's logs for complete > info: > > Caused by: com.sap… what? > > Seems more like a SAP side fault than a Hadoop side one and you should > ask on their forums with the stacktrace posted. > > On Thu, Feb 21, 2013 at 11:58 AM, samir das mohapatra > <samir.help...@gmail.com> wrote: > > Hi All > > Can you plese tell me why I am getting error while loading data from > > SAP HANA to Hadoop HDFS using sqoop (4.1.2). > > > > Error Log: > > > > java.io.IOException: SQLException in nextKeyValue > > at > > > org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:265) > > at > > > org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:458) > > at > > > org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:76) > > at > > > org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:85) > > at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139) > > at > > > org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:645) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:325) > > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > > at java.security.AccessController.doPrivileged(Native Method) > > at javax.security.auth.Subject.doAs(Subject.java:416) > > at > > > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1332) > > at org.apache.hadoop.mapred.Child.main(Child.java:262) > > Caused by: com.sap > > > > Regards, > > samir. > > > > > > > > -- > > > > > > > > > > -- > Harsh J >