Forum Post: Progress DataDirect connector for Hadoop Hive from Oracle - types issues

  • Thread starter Thread starter JIV
  • Start date Start date
Status
Not open for further replies.
J

JIV

Guest
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

Continue reading...
 
Status
Not open for further replies.
Back
Top