Hue Hive is not working properly.

[tom.ho...@ringcentral.com]

When I start up the Hive Query Editor

The database tables never load, the wheel just keeps spinning.

Any query I execute gives me this errer: java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

There is nothing listed under the settings tab other than enable paramaterization being checked

This is the URL for hive editor: https://<hadoop cluster name here>:8888/beeswax/#query

We are using HiveServer2

Cannot save a query file, get this error:  Could not save design: java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

I am not sure what other information that might be helpful.   Oh, Impala seems to be working normally...

Thanks for any help you can provide.

           -Tom

[Jenny Kim]

Tom what version of hue are you running?

To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+u...@cloudera.org.

[tom.ho...@ringcentral.com]

We are running 

Hue™ 3.7.0

[Jenny Kim]

When you go to /logs is there anything helpful in the stack trace?  Also are these external tables that are using a custom serializer (JAR file)?

On Friday, August 14, 2015, <tom.ho...@ringcentral.com> wrote:

To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+u...@cloudera.org.

[Erick Tryzelaar]

Hello Tom,

You could also try restarting the metastore, which might clear this up.

[tom.ho...@ringcentral.com]

I am a new to Hue, and just a user so I don't have access to a lot of areas.   Where would I find the /logs folder?   If i can find a stack trace, i'll definitely post it.    Also, it seems to be affecting me and a few other users, most Hue Hive users are not having these problems.

On Friday, August 14, 2015 at 10:07:23 AM UTC-4, tom.ho...@ringcentral.com wrote:

[Jenny Kim]

Ah, would it be possible for the Hue administrator to try restarting the metastore?

To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+u...@cloudera.org.

[Romain Rigaux]

You other users might not be using the same interface.

Is the beeline command working properly if you submit the same query?

http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/cdh_ig_hiveserver2_start_stop.html

Romain

[Tom Houlihan]

Romain,

Where would I enter beeline?    I have beeswax in my hive URL….if I change it to beeline the URL is not found.

 

Tom Houlihan

Office 650.318.5124 | Mobile 864.907.9991

[tom.ho...@ringcentral.com]

On Friday, August 14, 2015 at 10:07:23 AM UTC-4, tom.ho...@ringcentral.com wrote:

They have made some changes to my configuration, now the Hue Quick Start Wizard comes up when I start Hue.   The first thing it does is check my configuration, and I get this error:

Checking current configuration

Configuration files located in /var/run/cloudera-scm-agent/process/32058-hue-HUE_SERVER 

Potential misconfiguration detected. Fix and restart Hue.

Hive Editor

The application won't work without a running HiveServer2.

 Now what does this mean ???   Thanks for any help you can provide.

     -Tom

[Romain Rigaux]

This means Hue cannot communicate with HiveServer2 successfully (cf. above Java exception probably, meaning Hive is not configured properly).

Are you running the exact same query from the Hue machine as the hue user in beeline? I am trying to prove that the error comes from HiveServer2 not Hue (and this is a Java exception).

When you use the 'hive' command it is not the same as 'beeline'.

     -Tom

To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+u...@cloudera.org.

[Tom Houlihan]

Romain,

Thanks for your help with this issue.

There are other users where Hive works fine with Hue, where some of us it does not.

I can run the query from Hive on the Hadoop cluster, just not from Hue Hive.    Actually, it really does not matter what query I run in Hue, I get the same error…

Thanks.

    -Tom

 

Tom Houlihan

Office 650.318.5124 | Mobile 864.907.9991

 

From: Romain Rigaux [mailto:rom...@cloudera.com]
Sent: Monday, August 24, 2015 3:03 AM
To: Tom Houlihan
Cc: Hue-Users
Subject: Re: Hue Hive is not working properly.

 

This means Hue cannot communicate with HiveServer2 successfully (cf. above Java exception probably, meaning Hive is not configured properly).

[Tom Houlihan]

I am still getting this error on the Hue Quickstart:

 

Checking current configuration

Configuration files located in /var/run/cloudera-scm-agent/process/32058-hue-HUE_SERVER 

Potential misconfiguration detected. Fix and restart Hue.

 

Hive Editor

The application won't work without a running HiveServer2.

 

 

Tom Houlihan

Office 650.318.5124 | Mobile 864.907.9991

 

From: Tom Houlihan
Sent: Monday, August 24, 2015 10:17 AM
To: 'Romain Rigaux'
Cc: Hue-Users; Dennis Yavorsky; Youval Dar
Subject: RE: Hue Hive is not working properly.

 

Romain,

Thanks for your help with this issue.

There are other users where Hive works fine with Hue, where some of us it does not.

I can run the query from Hive on the Hadoop cluster, just not from Hue Hive.    Actually, it really does not matter what query I run in Hue, I get the same error…

Thanks.

    -Tom

 

Tom Houlihan

Office 650.318.5124 | Mobile 864.907.9991

 

From: Romain Rigaux [mailto:rom...@cloudera.com]
Sent: Monday, August 24, 2015 3:03 AM
To: Tom Houlihan
Cc: Hue-Users
Subject: Re: Hue Hive is not working properly.

 

This means Hue cannot communicate with HiveServer2 successfully (cf. above Java exception probably, meaning Hive is not configured properly).

[Erick Tryzelaar]

Hello Tom,

Just to be safe, does your cluster have a Hive Server 2 running, and is Hue configured to use it? It is possible to run Hive commands without the Hive Server 2 running, so perhaps that's how your users are using Hive.

One way to check is to follow these examples to try to connect to HiveServer2:

https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-BeelineExample

So something like:

```

% bin/beeline
Hive version 0.11.0-SNAPSHOT by Apache
beeline> !connect jdbc:hive2://localhost:10000 scott tiger org.apache.hive.jdbc.HiveDriver
!connect jdbc:hive2://localhost:10000 scott tiger org.apache.hive.jdbc.HiveDriver
Connecting to jdbc:hive2://localhost:10000
Connected to: Hive (version 0.10.0)
Driver: Hive (version 0.10.0-SNAPSHOT)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://localhost:10000> show tables;
show tables;
+-------------------+
|     tab_name      |
+-------------------+
| primitives        |
| src               |
| src1              |
| src_json          |
| src_sequencefile  |
| src_thrift        |
| srcbucket         |
| srcbucket2        |
| srcpart           |
+-------------------+
9 rows selected (1.079 seconds)

```

If beeline doesn't work for you, please setup talk to your cluster admins to get one running. If that works, then make sure that the hue configuration has:

```

[beeswax]

hue_server_host=localhost

hue_server_port=10000

```

Substitute `localhost` for whatever machine is running HiveServer2. Hopefully this'll work for you.

-Erick

[Tom Houlihan]

When I log into the server directly, I can get to the hiveserver2 fine.   It is just when I am in Hue that I cannot.   Others in Hue have no problems….

 

Tom Houlihan

Office 650.318.5124 | Mobile 864.907.9991

 

[Youval Dar]

FYI…

My Hue-Hive still does not work as well

(command line beeline is working)

thanks, Youval

[Romain Rigaux]

Did you register some jars, UDF or set some particular Hive properties in the editor?

Your HiveServer2 session might be messed up and not for the other users. Is restarting HiveServer2 an option to clear that?

[Tom Houlihan]

I have not configured anything in Hue, don’t know how.    Restarting HiveServer2 would affect the whole company…not sure if that is an option.

[Romain Rigaux]

How about:

http://gethue.com/hue-api-execute-some-builtin-commands/

HUE_CONF_DIR=/var/run/cloudera-scm-agent/process/-hue-HUE_SERVER-id echo $HUE_CONF_DIR export HUE_CONF_DIR

Then

open Hue shell and delete your last session:

from beeswax.models import Session
Session.objects.filter(owner__username='bob').latest("last_used").delete()