Support Questions
Find answers, ask questions, and share your expertise

How to access with a Hive database 'db_test' and not default from QLikView using ODBC driver?

How to access with a Hive database 'db_test' and not default from QLikView using ODBC driver?

New Contributor

Hi, My question is regarding QlikView connectivity with Hive. I have a database created in Hive with name db_test . And I want to access the tables under this 'db_test' database through ODBC connection, but I am unable to connect it is giving me error as SQL##f -SqlState: S0002, ErrorCode: 31740, ErrorMsg: [Hortonworks][SQLEngine](31740) Table or view not found: HIVE.db_test SQL SELECT * FROM HIVE.`db_test`.`emp_details` but when I am creating the same tables in default database I am able to access the tables. Why is this so? I feel like I am missing something very silly.

2 REPLIES 2
Highlighted

Re: How to access with a Hive database 'db_test' and not default from QLikView using ODBC driver?

New Contributor

Hi Avishek,

I'm facing the same issue. Do you by any chance have resolution to share ?

Thank you.

Highlighted

Re: How to access with a Hive database 'db_test' and not default from QLikView using ODBC driver?

New Contributor

Error may be due to incorrect hiveServer2 details in odbc.ini check that file

Don't have an account?