[Moving discussion to Apache SQOOP mailing list: sqoop-user@incubator.apache.org]
A JIRA has been opened for this issue: https://issues.apache.org/jira/browse/SQOOP-314 One workaround is to set the configuration variable "sqoop.export.records.per.statement" to 1 for now. However, this may impact the performance though... On Aug 17, 4:47 am, Aaparna Joshi <aaparna.ajo...@gmail.com> wrote: > Hi > > I am trying to export data from HDFS to Teradata using yje following > - > > bin/sqoop export --driver com.teradata.jdbc.TeraDriver --connect > jdbc:teradata://172.29.179.1/tduser --username tduser -P --table > TSEC4 --export-dir /user/hadoop/TSEC3/part-m-00000 --input-fields- > terminated-by ',' > > Following is the error I get every time when I run this - > > Caused by: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata > Database] [TeraJDBC 13.00.00.27] [Error 3706] [SQLState 42000] Syntax > error: expected something between ')' and ','. > at > com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFa ctory.java: > 317) > at > com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveIni tSubState.java: > 104) > at > com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine (StatementReceiveState.java: > 286) > at > com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(Statemen tReceiveState.java: > 177) > at > com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(Statement Controller.java: > 111) > at > com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementCont roller.java: > 102) > at > com.teradata.jdbc.jdbc_4.Statement.executeStatement(Statement.java: > 339) > at com.teradata.jdbc.jdbc_4.Statement.prepareRequest(Statement.java: > 506) > at > com.teradata.jdbc.jdbc_4.PreparedStatement.<init>(PreparedStatement.java: > 65) > at > com.teradata.jdbc.jdbc_4.TDSession.createPreparedStatement(TDSession.java: > 696) > at > com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.<init>(TeraLoc alPreparedStatement.java: > 89) > at > com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.prepareStatement(Tera LocalConnection.java: > 333) > at > com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.prepareStatement(Tera LocalConnection.java: > 152) > at com.cloudera.sqoop.mapreduce.ExportOutputFormat > $ExportRecordWriter.getPreparedStatement(ExportOutputFormat.java:142) > at > com.cloudera.sqoop.mapreduce.AsyncSqlRecordWriter.execUpdate(AsyncSqlRecord Writer.java: > 146) > at > com.cloudera.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWrite > > I saw a post on a similar error... but, what is the solution to this? > is there patch available to resolve this problem? > > Thanks, > Aparna Joshi
