Error while running hive query in hue 4.6 hive editor

kush · May 7, 2020, 7:43am

Hi ,

I am getting below error while running query in hive editor.

Error while compiling statement: FAILED: RuntimeException Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

Kindly advice.
@Romain

Thanks.

steven-dfheinz · May 7, 2020, 1:41pm

@Kush can you share some insight into how you have hive configured?

I have working hive configuration in the following file:

github.com

steven-dfheinz/HDP3-Hue-Service/blob/Hue.4.6.0/configuration/live.hue.ini


# Hue configuration file
# ===================================
#
# For complete documentation about the contents of this file, run
#   $ (hue_root)/build/env/bin/hue config_help
#
# All .ini files under the current directory are treated equally.  Their
# contents are merged to form the Hue configuration, which can
# can be viewed on the Hue at
#   http://(hue_host):(port)/dump_config


###########################################################################
# General configuration for core Desktop features (authentication, etc)
###########################################################################

[desktop]

  # Set this to a random string, the longer the better.

This file has been truncated. show original

kush · May 7, 2020, 2:01pm

@steven-dfheinz ,

The only difference between your configuration and mine is
use_sasl=true
which is commented out in my hue.ini.

Romain · May 8, 2020, 12:42am

Sounds like this error is about a Hive setup issue, not related to Hue.

kush · May 8, 2020, 2:00pm

Yes. this seems to be user specific. My team mates are able to access hive without issues. its just my id facing this error.

arturbrandysonwelo · August 1, 2022, 1:04pm

Hi. Yes, we have exactly the same problem. We must restart the HiveServer2 service (on the server which is written in the hue configuration file) to solve the problem temporarily.
But after some time another user gets this kind of problem while others are doing fine.

kush · August 2, 2022, 6:56pm

@arturbrandysonwelo,

I recommended you to ask the user to “recreate session” on Hive editor of the Hue console and the user will be able to run queries successfully. This might be a kerberized environment, recreating the session would help to the get/renew a kerberos ticket.

My users were able to fix the error by recreating the session. Below screenshot should help you how user can recreate the session.

arturbrandysonwelo · August 3, 2022, 8:03am

Thank you very much @kush for the solution, we will test it and I will let you know if it works in our environment.

arturbrandysonwelo · August 4, 2022, 12:58pm

Yes, this solution is working. Thank you very much for your help