Support Questions

Find answers, ask questions, and share your expertise

Hive in Hue time out error..

avatar
Expert Contributor

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..

1 ACCEPTED SOLUTION

avatar
Rising Star

You need to increase hive.heapsize for hive

View solution in original post

4 REPLIES 4

avatar
Rising Star

You need to increase hive.heapsize for hive

avatar
Expert Contributor

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...

avatar
Rising Star

Goto hive service config in ambari and search hive.heapsize

and edit hiveserver2 heap size

PFA screenshot

7724-javaheap.jpg

avatar
Expert Contributor

I am using HDP 2.1.2

I can't see this property i have screen short

hiveheap.png