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.

insert overwrite directory - beeline

Solved Go to solution

insert overwrite directory - beeline

Expert Contributor

INSERT OVERWRITE DIRECTORY '/tmp' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE SELECT visit_id, ivm from abcd.xyz WHERE feed_date BETWEEN '2006-04-01' and '2006-05-01' AND ivm IS NOT NULL limit 10;

Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [rvchinta] does not have [WRITE] privilege on [/tmp] (state=42000,code=40000) 0: jdbc:hive2://hostname.abc.com:8443>

ranger policy /tmp has 777 to public

HDP version 2.6.1

1 ACCEPTED SOLUTION

Accepted Solutions

Re: insert overwrite directory - beeline

Expert Contributor

i updated directory path to hdfs:CLUSTERNAMEHA/tmp and it worked.

5 REPLIES 5

Re: insert overwrite directory - beeline

Expert Contributor

I do not see this permission denied in ranger audit as well.

Re: insert overwrite directory - beeline

Expert Contributor

i updated directory path to hdfs:CLUSTERNAMEHA/tmp and it worked.

Re: insert overwrite directory - beeline

New Contributor

I can confirm that I had the same problem on HDP 2.6.3. Like suggested, using the fully qualified path (hdfs://<cluster>/path) makes it work.

Re: insert overwrite directory - beeline

New Contributor

INSERT OVERWRITE DIRECTORY "hdfs://sandbox-hdp.hortonworks.com/tmp/hey2" SELECT * FROM mytable;


(i.e. you need to specify full name of cluster) works fine when you have correct configuration in Ranger, but INSERT OVERWRITE DIRECTORY "/tmp/hey2" SELECT * FROM mytable; will fail. At least this is true for HDP 2.6.3

Re: insert overwrite directory - beeline

Explorer

Hi,

Is there a workaround solution for the above or is it a behaviour of 2.6.3 and above?

Don't have an account?
Coming from Hortonworks? Activate your account here