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