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 a 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



Applicable Infoworks Versions


2.X, 3.X