Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accessing MAPR HIVE tables using Qlik

Hi I am trying to access HIVE on MAPR by downloading MAPR ODBC driver (as mentioned in Hive ODBC Connector - Latest Documentation - doc.mapr.com).

We have setup a single node MAPR system  and created a table in HIVE (which I am able to query on HIVE command prompt). With ODBC setup, I am able to establish the conenction but while executing the following script  I am getting the Table or view not found error.

Can some one please help.

Script:

ODBC CONNECT TO [HIVE - 32 Bit] (XUserId is EfXdWWFMQTcCO, XPassword is feLASWFMQTccN);

test2:

SQL use default;

NoConcatenate Load *;

SQL select * from Hive.default.systemuser_test;

Error:

SQL##f - SqlState: S0002, ErrorCode: 31740, ErrorMsg: [MapR][SQLEngine] (31740) Table or view not found: Hive.default.systemuser_test

SQL select * from Hive.default.systemuser_test

0 Replies