A failure occurred while initializing FastExport resources for statement SELECT

Database

A failure occurred while initializing FastExport resources for statement SELECT

Hi I'm trying to export a table from teradata to hadoop via sqoop job.

When i'm trying to run the command i'm getting this error

Error: com.teradata.connector.common.exception.ConnectorException: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.10.00.26] [Error 1261] [SQLState HY000] A failure occurred while initializing FastExport resources for statement SELECT

these are the properties i'm setting up in my sqoop job,

15/04/27 05:49:24 INFO teradata.TeradataConnManager: Importing from Teradata Table:EBI_SCORE_FOR_COMET

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Setting input file format in TeradataConfiguration to textfile

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Table name to import EBI_SCORE_FOR_COMET

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Setting job type in TeradataConfiguration to hdfs

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Setting input file format in TeradataConfiguration to textfile

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Setting number of mappers in TeradataConfiguration to 4

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Setting input batch size in TeradataConfiguration to 1000

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Setting split by column in TeradataConfiguration to CUSTOMER_ACCOUNT_ID

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Setting input separator in TeradataConfiguration to \u007c

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Setting source table  to : EBI_SCORE_FOR_COMET

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Setting source conditions  to : month_end_int=201503

15/04/27 05:49:24 INFO teradata.TeradataSqoopImportHelper: Setting  split by column  to : CUSTOMER_ACCOUNT_ID

Can anyone let me know the issue??

The query will try to fetch 27428355 records.

Regards,

Apurv

Tags (1)