Cloudera Community
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
michael_napoleo
user rank
New Contributor

Re: hive creation of temp tables in default databa...

by New Contributor in Support Questions
‎03-20-2018 01:33 PM
‎03-20-2018 01:33 PM
Any idea if the temporary table created with the line to be inserted has to in the "default" database? Is there a setting to modify this behavior in hive such that I can tell it to use a database the user does have access to? ... View more

hive creation of temp tables in default database d...

by New Contributor in Support Questions
‎03-20-2018 12:48 PM
‎03-20-2018 12:48 PM
I have an INSERT statement, using the VALUES clause on a table that is formatted ORC and this table is not in the default database. When this INSERT attempts to run I get the following permissions error. Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [cdp8.admin] does not have [SELECT] privilege on [default/values__tmp__table__1/*] Does my user [cdp8.admin] need the SELECT privilege on the default database even though I'm not using it? ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎03-20-2018 01:33 PM
Community Statistics
Member Since ‎03-20-2018 12:42 PM
Last Visited ‎03-20-2018 01:33 PM
Posts 2