1. Causes
Hive — service hiverver2 reports an error, which makes the hiverver2 service unusable
2. Error information
Exception in thread “HiveServer2-Handler-Pool: Thread-556” java.lang.OutOfMemoryError: GC overhead limit exceeded
3. Reasons for error reporting
JVM started by hive shell script is out of memory
4. Solution
cp hive-env.sh.template hive-env.sh vi hive-env.sh Release export HADOOP_HEAPSIZE=1024 (if you still get an error, make the memory bigger)