Created 02-11-2016 04:55 AM
When I am trying to create DB with hIVE VIEW editor getting below error
org.apache.ambari.view.utils.hdfs.HdfsApiException: HDFS030 Error in creation /user/admin/hive/jobs/hive-job-2-2016-02-10_09-55...
Created 02-11-2016 06:00 AM
This is a know bug in Hive View and will be fixed in one of the upcoming Ambari versions. You can find a valid workaround in our Troubleshooting guide http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.0.0/bk_ambari_views_guide/content/troubleshootin...
The base problem is, that your user does not have a user directory in /user in HDFS
Created 02-11-2016 05:55 AM
@Swapnil Prabhu There are a couple of things to note
1. Views can be created on existing underlying table.
2. You must have the permissions to write to the /user/admin/hive/* directory
3. Upload the syntax for verification
Have a look at this doc too
Created 02-11-2016 05:57 AM
@Swapnil Prabhu Do you have /user/admin directory created in HDFS and with right permissions? Try
su - hdfs hdfs dfs -ls -d /user/admin hdfs dfs -mkdir /user/admin ... if /user/admin doesn't exist
If admin is not the owner of the directory try
hdfs dfs -chown -R admin:hdfs /user/admin
and then retry your Hive view action.
Created 02-11-2016 06:00 AM
This is a know bug in Hive View and will be fixed in one of the upcoming Ambari versions. You can find a valid workaround in our Troubleshooting guide http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.0.0/bk_ambari_views_guide/content/troubleshootin...
The base problem is, that your user does not have a user directory in /user in HDFS
Created 02-12-2016 07:42 PM
Thanks @Jonas Straub This worked
Created 06-28-2016 08:03 PM
I followed the instruction, but still getting the same error. I've checked directory and it looks good:
[hdfs@c6402 ~]$ hadoop fs -ls /user/admin/
Found 4 items
drwxrwxrwx - admin hadoop 0 2016-06-28 17:27 /user/admin/.Trash
drwxrwxrwx - admin hadoop 0 2016-06-28 14:11 /user/admin/.staging
drwxrwxrwx - admin hadoop 0 2016-06-28 14:11 /user/admin/employee_db
drwxr-xr-x - admin hadoop 0 2016-06-28 19:56 /user/admin/hive
Also, tried switching the group to HDFS but no luck. Any ideas?