In CDH4.7 VM,
If we create a hive table with user(cloud era), then run ooze job to access this table.
Error: org.apache.hadoop.security.AccessControlException: Permission denied: user=hive access=WRITE, inode="/user":cloudera:supergroup:drwxr-xr-x
1. ooze job create db: user 'hive'
2. hive -f created.hql: user 'hive'
3. hive -e 'create database db': user 'cloudera'
4. hive shell> create database db; : user 'cloudera'
One simple but temporal solution is:
1. in Cloudera Manager-> Hive-> Configuration -> Service-Wide->Advanced-> System User(hive to cloudera)
2. Save changes-> Actions-> Restart.
Then, 1, 2, will become user 'cloud era'
But in our CDH4.7 Cluster, only 1 is 'hive', 2, 3, 4 are 'cloud era'
No comments:
Post a Comment