please find below exception in beeline
beeline -u jdbc:hive://server:port/ -n user -e "insert into table schema.table_name values(1,'k')"
Hive access control exception permission denied for user on select privileges for [default/_tmp_value]
while running the same command in embedded mode im able to insert the data into hive table
beeline -u jdbc:hive:// -n user -e "insert into table schema.table_name values(1,'k')"
- Which version of Ambari and HDP are you using?
- Are you using Ranger ? If yes then you might want to see this and provide the needed priviledges to the user from Ranger side. https://community.hortonworks.com/content/supportkb/198363/errorfailed-hiveaccesscontrolexception-pe...