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.