question Re: Hive in Hue time out error.. in Support Questions

Hive in Hue time out error..

g_rao9704 — Wed, 14 Sep 2016 17:05:04 GMT

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

Re: Hive in Hue time out error..

balay80 — Thu, 15 Sep 2016 17:14:07 GMT

You need to increase hive.heapsize for hive

Re: Hive in Hue time out error..

g_rao9704 — Fri, 16 Sep 2016 13:02:56 GMT

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

Re: Hive in Hue time out error..

balay80 — Sun, 18 Aug 2019 12:57:28 GMT

Goto hive service config in ambari and search hive.heapsize

and edit hiveserver2 heap size

PFA screenshot

Re: Hive in Hue time out error..

g_rao9704 — Fri, 16 Sep 2016 16:48:57 GMT

I am using HDP 2.1.2

I can't see this property i have screen short

hiveheap.png