question Hue Not working with hive on tez in Support Questions

Hue Not working with hive on tez

dv_conan — Tue, 24 Aug 2021 15:25:55 GMT

Dear all

I have installed CDP private cloud on single node, Also i added hive, hive-on-tez and Hue services but unfortunately Hue not working with hive database and hiveserver2 of hive-on-tez stopping frequently.

On hue UI this error is shown while choosing hive database

Could not connect to any of [('xx.xx.xxx.xxx', 10000)] (code THRIFTTRANSPORT): TTransportException("Could not connect to any of [('xx.xx.xxx.xxx', 10000)]",)

So what shall i do to work on hive using hue editor?

thanks in advance

Re: Hue Not working with hive on tez

jAnshula — Tue, 24 Aug 2021 15:35:55 GMT

Hi @dv_conan

As you have mentioned that hiveserver2 of hive-on-tez is stopping frequently. This seems to be the cause of this error, as this message indicates that Hive Server is down or HUE Can't reach the server.

Please check Hive server logs to see why the hiveserver2 on hive-on-tez is failing frequently.

Re: Hue Not working with hive on tez

dv_conan — Wed, 25 Aug 2021 14:47:22 GMT

Hi @jAnshula

Thanks for your reply,

I've already checked Hive server2 logs and this what i got in the screenshot below.

And i didn't find out what that error mean and how to solve it. am still cannot working with Hue

Re: Hue Not working with hive on tez

jAnshula — Wed, 25 Aug 2021 15:18:06 GMT

@dv_conan

It seems that Tez tar file is not uploaded to HDFS.

Can you try and manually upload the Tez tar file to HDFS manually

Go to CM -> Tez -> Actions -> "Upload Tez tar file to HDFS.

Let us know if resolves your issue

Re: Hue Not working with hive on tez

dv_conan — Thu, 26 Aug 2021 13:27:28 GMT

@jAnshula

I tried it but still not working and i have the same error !

Re: Hue Not working with hive on tez

Shelton — Thu, 26 Aug 2021 19:36:40 GMT

@dv_conan
I think your issue should be resolved with this posting
Hive on tez issue
Please let me know if that resolves your problem or not

Re: Hue Not working with hive on tez

dv_conan — Sun, 29 Aug 2021 12:31:54 GMT

@Shelton
I have seen that solution before, but it is also not working after i added this command to /etc/hive/conf/hive-env.sh

TEZ_JARS="/opt/cloudera/parcels/CDH/jars/tez-:/opt/cloudera/parcels/CDH/lib/tez/.jar:$CONF_DIR/tez-conf"

and then restarted the service but hivserver2 still stopping frequently

Re: Hue Not working with hive on tez

asish — Tue, 14 Sep 2021 06:48:47 GMT

Could you please attach hive on Tez logs.

Please start Hive on Tez and wait till it crash completely and the provide the logs.

Please attach the logs from below location:

a. /var/logs/hive

b. /var/run/cloudera-scm-agent/process/<hove on tez>/logs

Please also try setting hive.server2.tez.initialize.default.sessions=false in CM and check.

Re: Hue Not working with hive on tez

VidyaSargur — Tue, 21 Sep 2021 07:55:05 GMT

Hi @dv_conan Has any of the replies helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. If you are still experiencing the issue, can you provide the information that is requested?