question Re: insert overwrite directory - beeline in Archives of Support Questions (Read Only)

insert overwrite directory - beeline

chrsvarma — Tue, 11 Jul 2017 04:28:47 GMT

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

Re: insert overwrite directory - beeline

chrsvarma — Tue, 11 Jul 2017 04:29:48 GMT

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

Re: insert overwrite directory - beeline

chrsvarma — Tue, 11 Jul 2017 04:38:28 GMT

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

Re: insert overwrite directory - beeline

cros_romain — Sat, 27 Jan 2018 03:47:35 GMT

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

the_best_specia — Sat, 10 Feb 2018 02:20:42 GMT

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

teravaidya — Tue, 15 May 2018 15:21:41 GMT

Hi,

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