question Unable to overcome this exception (HiveAccessControlException Permission denied: user [admin] does not have [READ] ) in Archives of Support Questions (Read Only)

Unable to overcome this exception (HiveAccessControlException Permission denied: user [admin] does not have [READ] )

sairamv — Fri, 16 Sep 2022 10:00:30 GMT

I am trying to run this sample, http://hortonworks.com/hadoop-tutorial/how-to-refine-and-visualize-server-log-data/

sudo -u hdfs hadoop fs -chmod -R 777/flume

/flume - no such file or directory.

Re: Unable to overcome this exception (HiveAccessControlException Permission denied: user [admin] does not have [READ] )

aervits — Wed, 27 Jan 2016 19:16:21 GMT

@Sai ram

sudo -u hdfs hdfs -mkdir /flume

sudo -u hdfs hdfs -chmod -R 777 /flume

Re: Unable to overcome this exception (HiveAccessControlException Permission denied: user [admin] does not have [READ] )

sairamv — Mon, 19 Aug 2019 11:08:36 GMT

@Artem Ervits PFA.

Re: Unable to overcome this exception (HiveAccessControlException Permission denied: user [admin] does not have [READ] )

nsabharwal — Wed, 27 Jan 2016 19:28:02 GMT

Hi @Sai ram

Your question title and description does not match.

I have looked into the article and looks like /flume does not exist.

if the query doesn’t run successfully due to a permissions error you then you might need to update the permission on the directory. Run the following commands over SSH on the Sandbox

<code>sudo -u hdfs hadoop fs -mkdir /flume

<code>sudo -u hdfs hadoop fs -chmod -R 777 /flume
sudo -u hdfs hadoop fs -chown -R admin /flume

Re: Unable to overcome this exception (HiveAccessControlException Permission denied: user [admin] does not have [READ] )

aervits — Wed, 27 Jan 2016 19:29:28 GMT

@Sai ram

Sorry

Sudo -u hdfs hdfs dfs -mkdir /flume

Sudo -u hdfs hdfs dfs -chmod -R 777 /flume

It's too early 🙂

Re: Unable to overcome this exception (HiveAccessControlException Permission denied: user [admin] does not have [READ] )

sairamv — Mon, 19 Aug 2019 11:08:28 GMT

Hi @Neeraj Sabharwal

I still get this error,

Re: Unable to overcome this exception (HiveAccessControlException Permission denied: user [admin] does not have [READ] )

nsabharwal — Wed, 27 Jan 2016 19:35:20 GMT

@Sai ram

sudo -u hdfs hadoop fs -chmod -R 777 /flume

Re: Unable to overcome this exception (HiveAccessControlException Permission denied: user [admin] does not have [READ] )

geko — Wed, 27 Jan 2016 20:28:18 GMT

Hi @Sai ram ,

looks like you are using Ranger and you do not have a Ranger-HDFS-policy which allows the user hive to write to "/flume"

On the one hand, the solution from @Neeraj Sabharwal is granting permissions on HDFS level and solves your problem, on the other hand, if you want to go with Ranger I'd recommend to create/adjust Ranger-HDFS-policies for certain folders/users (and do a, at least, chmod 700 on HDFS level itself to prevent accessing folders/files "by accident")