Created 09-14-2016 10:05 AM
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..
You need to increase hive.heapsize for hive
Created 09-16-2016 06:02 AM
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...
Created on 09-16-2016 07:14 AM - edited 08-18-2019 05:57 AM
Goto hive service config in ambari and search hive.heapsize
and edit hiveserver2 heap size
Created 09-16-2016 09:48 AM