Reply
Highlighted
New Contributor
Posts: 4
Registered: ‎10-20-2018
Accepted Solution

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

[ Edited ]

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

Posts: 26
Topics: 0
Kudos: 8
Solutions: 2
Registered: ‎07-30-2018

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

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
New Contributor
Posts: 4
Registered: ‎10-20-2018

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

Thanks, That worked like a charm
Announcements
New solutions