Teradata and Hadoop Hive Data Type mapping

Extensibility

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

2 REPLIES

Re: Teradata and Hadoop Hive Data Type mapping

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

Teradata Employee

Re: Teradata and Hadoop Hive Data Type mapping

Hi all,

Has someone already defined this kind of mapping?

It will be very useful.

Thanks,

Luca