Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
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

avatar
Expert Contributor
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

View solution in original post

2 REPLIES 2

avatar
Expert Contributor
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

avatar
Explorer
Thanks, That worked like a charm