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

[#1]

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

[#2 · Accepted solution]

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

[#3]

Thanks, That worked like a charm