Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

Import failed: com.teradata.connector.common.exception.ConnectorException: Input source table is emp

SOLVED Go to solution

Import failed: com.teradata.connector.common.exception.ConnectorException: Input source table is emp

Explorer

Sqoop import fails on empty table

We have a batch job that looks into Teradata table and offloads delta records to HIVE based on a timestamp column.

We havent used SQOOP incremental mode, Instead we have setup views on top of teradata tables and a joined to a control table to get the delta records.

Once the offload is completed, We update the control table with MAX of timestamp record.

 

However, We are stuck with below issue: Import failed: com.teradata.connector.common.exception.ConnectorException: Input source table is empty

 

Could someone assist on the same?

Regards, SV

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Import failed: com.teradata.connector.common.exception.ConnectorException: Input source table is

Rising Star
Hi,

When importing an empty table from Teradata to HDFS via Sqoop using the --table option, We are getting the below exception

com.teradata.connector.common.exception.ConnectorException: Input source table is empty

Its a bug from teradata end and the fix is yet to be released.

Until the fix is available, We recommend using sqoop import --query as a workaround instead of --table

Hope it helps. Let us know if you have any questions

Thanks
Jerry
2 REPLIES 2
Highlighted

Re: Import failed: com.teradata.connector.common.exception.ConnectorException: Input source table is

Rising Star
Hi,

When importing an empty table from Teradata to HDFS via Sqoop using the --table option, We are getting the below exception

com.teradata.connector.common.exception.ConnectorException: Input source table is empty

Its a bug from teradata end and the fix is yet to be released.

Until the fix is available, We recommend using sqoop import --query as a workaround instead of --table

Hope it helps. Let us know if you have any questions

Thanks
Jerry

Re: Import failed: com.teradata.connector.common.exception.ConnectorException: Input source table is

Explorer
Thanks, That worked like a charm