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 


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


Please follow below steps to overcome the issue



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



2) Recrawl schema.


3) Initialize and ingest the table

Applicable Infoworks Versions

2.X, 3.X