Create DB in Hive

[#1]

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...

[#2]

@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

[#3]

@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.

[#4 · Accepted solution]

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

[#5]

Thanks @Jonas Straub This worked

[#6]

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?