All Forums Extensibility
sourabhpotnis 3 posts Joined 01/14
10 Mar 2014
Teradata and Hadoop Hive Data Type mapping

Hi,
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?

 

Thanks,
Sourabh

jsclancy 1 post Joined 02/15
11 Dec 2015

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.
Thanks,
Scott

luca.natali 2 posts Joined 09/15
08 Jun 2016

Hi all,
Has someone already defined this kind of mapping?
It will be very useful.
Thanks,
Luca

--------------------------------------------------------
Luca Natali
https://it.linkedin.com/in/lucanatali

You must sign in to leave a comment.