Hive in Hue time out error..

[#1]

Hi i am using HDP 2.1.2 and and Hive(Beewex) on HUE and trying to run simple queries like "show databases" and its take lang time and says "time out" i can run same query in hive CLI

i have error log

INFO tez.TezSessionState: User of session id baacb86a-e54d-4fae-8c16-fff9834d4d8a is y919122 16/08/02 01:11:03 INFO tez.DagUtils: Jar dir is null/directory doesn't exist. Choosing HIVE_INSTALL_DIR - hdfs:/user/y919122/.hiveJars 16/08/02 01:12:52 ERROR thrift.ProcessFunction: Internal error processing query

java.lang.OutOfMemoryError: Java heap space

I have Check in beeswax_server.sh and trying to find HADOOP_HEAPSIZE property but i could not find ..please help its is pending since long..its is highly appreciated if u can help me..

[#2 · Accepted solution]

You need to increase hive.heapsize for hive

[#3]

Thank you so much@Balkrishna Yadav

But how could find these property i am looking in Amari>hive>advanced properties but i could not find please suggest me...

[#4]

Goto hive service config in ambari and search hive.heapsize

and edit hiveserver2 heap size

PFA screenshot

[#5]

I am using HDP 2.1.2

I can't see this property i have screen short

hiveheap.png