question Re: Create DB in Hive in Archives of Support Questions (Read Only)

Create DB in Hive

swapnilspra — Thu, 11 Feb 2016 12:55:28 GMT

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

Shelton — Thu, 11 Feb 2016 13:55:39 GMT

@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

pminovic — Thu, 11 Feb 2016 13:57:33 GMT

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

jstraub — Thu, 11 Feb 2016 14:00:40 GMT

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/troubleshooting.html

The base problem is, that your user does not have a user directory in /user in HDFS

swapnilspra — Sat, 13 Feb 2016 03:42:01 GMT

Thanks @Jonas Straub This worked

essex210 — Wed, 29 Jun 2016 03:03:24 GMT

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?