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.
I'm facing the same issue. Do you by any chance have resolution to share ?
Error may be due to incorrect hiveServer2 details in odbc.ini check that file