We’re implementing Proof of Concept project on Hive and ODBC connectivity.
We’re running Hive with Hiveserver2. We’ve established connection to Hive from MS SQL 2012 sp1 via linked server, which uses System DSN (ODBC datasource) based on Hortonworks ODBC driver v18.104.22.1685 (64 bit).
We’ve created a database view, which uses OPENQUERY to access Hive and run command.
Everything appears to be OK until we launch parallel selects from the view. The first view returns data, while others crash with errors:
OLE DB provider “MSDASQL” for linked server “hortonhive” returned message “[Hortonworks][Hardy] (35) Error from Hive: error code: ‘0’ error message: ‘java.io.IOException: java.lang.ArrayIndexOutOfBoundsException’.”.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider “MSDASQL” for linked server “hortonhive”.