question Re: Hive View Not Populating Database Explorer in Archives of Support Questions (Read Only)

Hive View Not Populating Database Explorer

zblanco — Mon, 19 Aug 2019 12:57:33 GMT

I've downloaded the latest sandbox and I'm running through a tutorial. It seems that the Hive view in Ambari can execute commands, but the Database Explorer will not show any of the tables that are present.

However I can still execute statements and receive the results. I just can't see the list of tables. It's not throwing any errors up on the screen so I'm not sure what's wrong.

Is there any way to fix this?

Re: Hive View Not Populating Database Explorer

nsabharwal — Fri, 16 Oct 2015 20:45:10 GMT

@zblanco@hortonworks.com

Please launch mysql cli and check for databases ? Just want to make sure that you have privilege to see show databases;

Re: Hive View Not Populating Database Explorer

jstraub — Fri, 16 Oct 2015 21:28:49 GMT

Could you share some log and configurations? I'd be interested in the log that is produced when you open that view or press the refresh button of the database explorer

Re: Hive View Not Populating Database Explorer

deepesh1 — Fri, 16 Oct 2015 23:43:21 GMT

The tables that you are expecting, were they created from the Hive View? I ran into issues with the tables getting refreshed. Can you kill session and launch new?

Re: Hive View Not Populating Database Explorer

zblanco — Fri, 16 Oct 2015 23:44:22 GMT

It showed all of the databases when I ran the mysql command

It could possibly be an issue with user permissions - and the 'admin' user that the view is using does not have access to the hive databases or tables.

I found this out by ssh'ing into the sandbox and I tried immediately running hive

[root@sandbox ~]# hive

gave me the error

org.apache.hadoop.security.AccessControlException: Permission denied: user=root, access=WRITE, inode="/user/root":hdfs:hdfs:drwxr-xr-x

However if I did a "su hdfs" or "su hive", it would allow me to run hive and see the tables.

Where I'm stumped is why I could run

select * from table_name;

and still have all the results returned.

Re: Hive View Not Populating Database Explorer

zblanco — Fri, 16 Oct 2015 23:45:43 GMT

I think it's an issue with user permissions, but I don't know why I can still run commands like

select * from table_name;

Re: Hive View Not Populating Database Explorer

deepesh1 — Fri, 16 Oct 2015 23:55:10 GMT

Could table_name be an external table with location that is readable by admin?

Re: Hive View Not Populating Database Explorer

zblanco — Fri, 16 Oct 2015 23:58:10 GMT

I suppose so? I was really just using it as a place holder. See screenshot in original question. That "trucks_stage" table, I was able to read and load from.

Re: Hive View Not Populating Database Explorer

deepesh1 — Sat, 17 Oct 2015 01:46:04 GMT

Have you followed the instructions from Ambari documentation for configuring Hive view. It states there:

Ambari views use the doAs option for commands. This option enables the Ambari process user to impersonate the Ambari logged-in user. To avoid receiving permissions errors for job submissions and file save operations, you must create HDFS users for all Ambari users that use the views.

The HDFS permission error that you are showing above:

org.apache.hadoop.security.AccessControlException: Permission denied: user=root, access=WRITE, inode="/user/root":hdfs:hdfs:drwxr-xr-x

It clearly shows that the /user/root which is the default user home of root user on HDFS is not owned by root, that's a problem. Can you make sure that /user/root is created with ownership of root user. Also if the authorization mode in Hive is StorageBased then /apps/hive/warehouse should be writable by root. This is usually accomplished by having the executing user in the same group as the one that has write permissions on /apps/hive/warehouse.

I would also guess that in your current setup any query that requires a job to be run will fail. Simple metadata queries would succeed.

Re: Hive View Not Populating Database Explorer

aervits — Wed, 03 Feb 2016 03:44:12 GMT

@zblanco are you still having issues with this? Can you accept best answer or provide your own solution?

Re: Hive View Not Populating Database Explorer

zblanco — Wed, 03 Feb 2016 22:37:19 GMT

I ended up restarting the Sandbox and my problem was eventually fixed.

Re: Hive View Not Populating Database Explorer

prakashpunj — Mon, 29 Feb 2016 12:25:48 GMT

Anyone has idea of this issue. Having the same issue. Below is what i have tried so far:

a.) Rebooted the machine

b.) I can see all the databases HDFS fole browser /apps/hive/warehouse

c.) Can list all databases using HIVE console

d.) Can also list tables using Hive console

e.) The only weird thing I notices is that it takes a very long time to get to hive prompt..

[hdfs@hdp-m ~]$ hive
WARNING: Use "yarn jar" to launch YARN applications.


Logging initialized using configuration in file:/etc/hive/2.3.4.0-3485/0/hive-log4j.properties
hive> show databases;
OK
arvindtest
dbforall
default
guestdatabase
kemr_fst
kemrfst
punj
punjtest
Time taken: 1.923 seconds, Fetched: 8 row(s)
hive>