Tuesday, September 09, 2014

HiveAccessControlException Permission Denied. (Error from hive: error code:'40000')



While importing data from Hortonworks Hive DSN in office 2013 and you faced error for HiveAccessControlException Permission Denied.



Login to console for hortonworks using root (hadoop). Goto hive shell and grant permission to the table you are trying to import.

hive> grant SELECT on table m_user to user hue;

And then re-import the table in office 2013.


No comments: