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.

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

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

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
Highlighted

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

Explorer
Thanks, That worked like a charm