question Re: hive view not exploring default databases ? in Archives of Support Questions (Read Only)

hive view not exploring default databases ?

rupinderkaoni — Sun, 07 Feb 2016 13:10:09 GMT

As i am installed hadoop using hdp on ec2 amazon cloud.

architecture is :

1 node on which ambari server is installed

2 master nodes

3 data nodes

So i have total 6 machines in the cluster. But when i open the hive view on my browser some syntax error is shown and hive default databases were not open. I also configure all the views according to the hortonworks documents. Please help me. I have also attached the screenshot of error.

Re: hive view not exploring default databases ?

pminovic — Sun, 07 Feb 2016 13:32:12 GMT

Hi @Rupinder Singh, and welcome to HCC!

We need more details to help you with your Hive view: Can you click on one of those "Syntax error" lines and attach the screenshot together with the screenshot of you Hive view settings. Also, can you tell us: Your version of HDP and Ambari, are you using Namenode HA, and your Hive port and Hive transport (binary or http). And by the way, can you list default Hive db from the command line? Tnx.

Re: hive view not exploring default databases ?

Shelton — Sun, 07 Feb 2016 16:34:28 GMT

@Rupinder Singh

Try starting the Database and retry but the info you gave doesn't help much in the diagnosis !

Re: hive view not exploring default databases ?

rupinderkaoni — Mon, 19 Aug 2019 09:40:33 GMT

thanks @Predrag minovic for replying

Here i find one more issue as i unable to login into hive from terminal as ec2-user or root

Syntax error is simple text and have no link

I also uploaded the hive view settings screenshot here

My hdp version is 2.3 and ambari version is 2.1 or 2.2

hive server2 port =10000

hive.server2.transport.mode = binary

Re: hive view not exploring default databases ?

pminovic — Sun, 07 Feb 2016 17:40:42 GMT

Okay, as root do this

su -l hdfs -c "hdfs dfs -chown -R ec2-user:hdfs /user/ec2-user"

And retry first from cmdline as ec2-user, and if it works try the view again, logging to Ambari as ec2-user.

Edit: Sorry, I forgot "-c". The problem is that ec2-user doesn't have permissions to his home directory in hdfs.

Re: hive view not exploring default databases ?

SK1 — Sun, 07 Feb 2016 18:41:02 GMT

Hello Rupinder,

It seems a permission issue on your home dir in hdfs. So change the owner to yourself and then try.

$ sudo su - hdfs

$ hadoop fs -chown ec2-user:hdfs /user/ec2-user

If still you face issue please paste logs/error here.

Re: hive view not exploring default databases ?

nsabharwal — Sun, 07 Feb 2016 21:58:02 GMT

@Rupinder Singh Adding to this

sudo su - hdfs

hdfs dfs -mkdir -p /user/root

hdfs dfs -chown -R root:hdfs /user/root