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

[#1]

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]

Hi Avishek,

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

Thank you.

[#3]

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