Progress DataDirect connector for Hadoop Hive from Oracle - types issues - Forum - DataDirect Connect - Progress Community

Progress DataDirect connector for Hadoop Hive from Oracle - types issues

 Forum

Progress DataDirect connector for Hadoop Hive from Oracle - types issues

This question is answered

Hello,

we are evaluating your product - DataDirect for connecting to Hive DB from Oracle DB. So far we managed successfully create DB link from oracle but some types give us strange results.

For example String are interpreted in oracle as Long. I know in Hive there is unlimited size for String but how we could get them as Varchar? Maybe limit size of string in odbc.ini to 4000?

Another thing is DateTime. If such column is selected in Oracle from Hive it shows as random byte stream. Hex preview:  78 6F 07 17 08 01 2F (should be 2011-07-23 07:00:46). And have no idea how get Date from such value.

JV

Verified Answer
All Replies