Forum Post: 00272637 (IBM) - Unable to select from Binary data from Hive 2Sever using Connect...

  • Thread starter Tech Support Gateway
  • Start date
Status
Not open for further replies.
T

Tech Support Gateway

Guest
To get more information about this case please go to: http://webappinternal.progress.com/serviceCloud/caseView.action?caseNumber=00272637 Sanjeev Aggarwal is requesting assistance to support IBM. IBM reported they were asked to upgrade to Hive 2 for some other functionality they were looking for and after upgrading to Hive 2 server they can't select the data from Binary field which used to work with hive 1. I am able to reproduce the issue here. SQL create table a(col1 string, col2 binary) Enter SQL statements (Press ENTER to QUIT) SQL desc a col_name data_type comment col1 string None col2 binary None Enter SQL statements (Press ENTER to QUIT) SQL select col2 from a SQLSTATE = S1000 NATIVE ERROR = 1201 MSG = [DataDirect][ODBC Apache Hive Wire Protocol driver]Unsupported data type in column 1. After I spoke to Chip in development he mentioned Binary data support was removed from Hive 2 because: // HiveServer2 currently has a // bug wherein selecting non-null binary data triggers a server ClassCastException in the Hive2 Server, // so we've opted *not* to support binary for the Hive2. Do we have any plans of adding the support for Binary data again in HiveServer2. Our Documentation states Binary data is Supported only with Apache Hive 0.8.1 and higher. Thanks, Sanjeev ref:_00D307FS._500a0hjmCB:ref

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