Problem Description


Teradata Ingestion fails with errors like below:


org.apache.sqoop.orm.ClassWriter:581 :: Cannot resolve SQL type 2002

org.apache.sqoop.orm.ClassWriter:751 :: No Java type for SQL type 2002 


Cause


The error is seen when Teradata source tables have data type of ‘PERIOD’ 


Solution


Please follow below steps to overcome the issue

 

 

1) Add “PERIOD(TIMESTAMP)=String“ entry in teradataMappings file at this location:


$IW_HOME/conf/mappings/teradataMappings

 

2) Recrawl schema.

 

3) Initialize and ingest the table