Re: Getting error when using sqoop export to Teradata

[Bilung Lee <bl...@gmail.com>]

[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 <aa...@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