topic Re: Need help for connecting amazon_hive db in QlikView

Need help for connecting amazon_hive db

saradhi_it — Thu, 19 Jan 2017 07:22:12 GMT

I recently installed AmazonHiveODBC64.msi connector in qlikview when we are feteching some data from hive it was throwing some error like QVX_ pipe error but if i check in the log the error was

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 35, ErrorMsg: [Amazon][HiveODBC] (35) Error from server: error code: '0' error message: 'java.io.IOException: java.lang.IllegalStateException: Connection pool shut down'.

Error: ODBC read failed

Regards

Pardhu

Re: Need help for connecting amazon_hive db

Thu, 19 Jan 2017 08:13:23 GMT

Perhaps try using the JDBC connector:

https://s3.amazonaws.com/amazon-odbc-jdbc-drivers/public/AmazonHiveJDBC_1.0.4.1004.zip

Re: Need help for connecting amazon_hive db

saradhi_it — Thu, 19 Jan 2017 09:23:48 GMT

I already downloaded amazon odbc driver for this ....we are using only odbc jdbc was too old to use i think do you implemented or used in qlikview

Regards

Pardhu