Hue Not working with hive on tez

[#1]

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 

[#2]

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.

[#3]

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  

[#4]

@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

[#5]

@jAnshula 

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

[#6]

@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 

[#7]

@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 

[#8]

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.

[#9]

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?