sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adam Smieszny <ad...@cloudera.com>
Subject Re: sqoop with teradata connector
Date Thu, 19 Apr 2012 23:11:03 GMT
+sqoop-user
+BCC cdh-user
Hi Mugi,
These type of questions may be best on sqoop-user list. I've moved it there.
More information would be useful in order to help us diagnose.
Can you please share the table schema and the sqoop command that you are
executing?

Thanks,
Adam

On Thu, Apr 19, 2012 at 7:05 AM, mugi <i9um0p@gmail.com> wrote:

> hi,
>
> i got an error when execute sqoop, below are error generated  by
> sqoop
>
> java.io.IOException: com.teradata.jdbc.jdbc_4.util.JDBCException:
> [Teradata JDBC Driver] [TeraJDBC 14.00.00.09] [Error 1151] [SQLState
> HY000] A failure occurred while setting a parameter value for database
> table "EDWIN"."SASN_EDR_T_temp_0". Details of the failure can be found
> in the exception chain that is accessible with getNextException.
>        at
>
> com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:
> 133)
>        at
>
> com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:
> 27)
>        at org.apache.hadoop.mapred.MapTask
> $NewDirectOutputCollector.write(MapTask.java:531)
>        at
>
> org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutputContext.java:
> 80)
>        at
> com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:
> 80)
>        at
> com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:
> 38)
>        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
>        at
>
> com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:
> 187)
>        at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
>        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
>        at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
>        at java.security.AccessController.doPrivileged(Native Method)
>        at javax.security.auth.Subject.doAs(Subject.java:396)
>        at
>
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:
> 1127)
>        at org.apache.hadoop.mapred.Child.main(Child.java:264)
> Caused by: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC
> Driver] [TeraJDBC 14.00.00.09] [Error 1151] [SQLState HY000] A failure
> occurred while setting a parameter value for database table
> "EDWIN"."SASN_EDR_T_temp_0". Details of the failure can be found in
> the exception chain that is accessible with getNextException.
>        at
>
> com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:
> 93)
>        at
>
> com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:
> 68)
>        at
>
> com.teradata.jdbc.jdbc.fastload.FastLoadManagerPreparedStatement.setString(FastLoadManagerPreparedStatement.java:
> 1790)
>        at
>
> com.cloudera.sqoop.lib.JdbcWritableBridge.writeString(JdbcWritableBridge.java:
> 188)
>        at SASN_EDR_T.write(SASN_EDR_T.java:191)
>        at
>
> com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:
> 124)
>        ... 14 more
>
> i install sqoop as cloudera recommendation but it still error, any
> reply will be greatly appreciate
>
> -mugi-
>



-- 
Adam Smieszny
Cloudera | Systems Engineer | http://tiny.cloudera.com/about
917.830.4156 | http://www.linkedin.com/in/adamsmieszny

Mime
View raw message