question Re: Import failed: com.teradata.connector.common.exception.ConnectorException: Input source table is in Support Questions

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

sridarvs — Fri, 16 Sep 2022 14:01:31 GMT

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

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

Jerry — Thu, 03 Jan 2019 18:42:16 GMT

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

sridarvs — Thu, 03 Jan 2019 23:36:13 GMT

Thanks, That worked like a charm