When I am trying to export data from Hadoop Hive to Teradata I am getting Datatype mismatch exception, especially for Date and Decimal format.
Just for testing, I tried to export the same Hive table to TD, that was imported from TD into Hive with same schema. But it didn't work.
So I changed everything to Varchar in Teradata, then the import was successful.
Is there a Data types mapping available between Teradata and Hive?
December 11, 2015
Teradata and Hadoop Hive Data Type mapping
Has anyone found a data types mapping available between Teradata and Hive yet? Offloading ETL from Teradata to Hadoop and need Teradata data type equivalents for Hive.