Member since
01-20-2017
1
Post
1
Kudos Received
0
Solutions
01-20-2017
05:21 PM
1 Kudo
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.
... View more