CDH4 Hive Configuration

Question

I am facing Permission denied error while creating HIVE table . Below is the detail description what I did .

I have 2 node clusture running on Ubuntu12.04 . I have installed CDH4.7.0 and they are up and running . I have installed HIVE by issuing below command . Apart from this command I did nothing for configuration as I have no idea what to do after installation:

sudo apt-get install hive

After installation I started HIVE . But when I am trying to create table I am getting below exception . I am not sure what permission I need to provide to which folder or user .

FAILED: Error in metadata: MetaException(message:Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=root, access=WRITE, inode="/user":hdfs:hadoop:drwxr-xr-x

I am running HIVE query under root user .

score 0 · Answer 1 · edited May 23 '17 at 10:24

0

This Error is related to HDFS;you can solve this problem temporary by disabling the dfs permission.By adding below property code to hdfs-site.xml

<property>
    <name>dfs.permissions</name>
    <value>false</value>
  </property>

if you want more options : Permission denied at hdfs

edited May 23 '17 at 10:24

Community

1
1

answered Feb 17 '15 at 08:31

Yosser Abdellatif Goupil

789
3
10
26

I made the changes in hdfs-site.xml but still getting the same error while creating table in hive . – Deb Feb 17 '15 at 14:28
try this : sudo chmod -R og+rx /usr/local/hive/metadata – Yosser Abdellatif Goupil Feb 17 '15 at 14:43
please validate the answer – Yosser Abdellatif Goupil Feb 18 '15 at 17:11

score 0 · Accepted Answer · answered Feb 23 '15 at 14:18

0

Alternatively you can use this to resolve it :

hadoop fs -chmod -R 777 /user/hive/warehouse/

answered Feb 23 '15 at 14:18

Devi Prasad

78
2
13

CDH4 Hive Configuration

2 Answers2