The following worked for me on sandbox 2.1 grant SELECT on table webloganalytics to user hue ...
The following worked for me on sandbox 2.1
grant SELECT on table webloganalytics to user hue
I have created an ODBC connection to the Sandbox 2.1 but I am not able to pull any data. The error I get is “ODBC–call failed. [Hortonworks][HiveODBC]  Error from Hive: error code: ’40000′ error message: ‘Error while compiling statement: FAILED: HiveAccessControlException Permission denied. Principal [name=hue, type=USER] does not have following privileges on Object [type=TABLE_OR_VIEW, name=<table name>]: [SELECT]‘, [#35]”
This works when I use the same setup to connect to the Sandbox 2.0, I have used it many times for moving data, mostly to MS Access.
I have tried different user names in the ODBC connection such as root, hdfs, and hadoop. I have tried various permissions on the table itself using table>view>view file location>change permissions. These did not solve it.
Any help would be appreciated.
You must be logged in to reply to this topic.