Installed Sandbox 2.1 and followed the tutorial to install the ODBC driver. Configured per the tutorial with user hue and no password. In my application I am using to connect, I am able to test the connection successfully, and also see the tables and fields. When I try to pull data though, I get the following error:
ERROR [HY000] [Hortonworks] [HiveODBC] (35) Error from Hive: error code: ‘40000’ error message: ‘Error while compiling statement: FAILED: HiveAccessControlException Permission denied. Principal [name=hue, type=USER] does not have the following privileges on Object [type=TABLE_OR_VIEW, name=default.sample_07]: [SELECT]’.
I’ve seen a similar post or two with no responses. Anybody have any ideas on this one?
Thanks in advance for any help!