Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

beeline issue while running insert statement

Highlighted

beeline issue while running insert statement

New Contributor

Hi all,

please find below exception in beeline

beeline -u jdbc:hive://server:port/ -n user -e "insert into table schema.table_name values(1,'k')"

error below

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')"
1 REPLY 1

Re: beeline issue while running insert statement

Super Mentor

@Naresh Ar

- 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...