question Hive Query Error:java.lang.OutOfMemoryError: Java heap space in Archives of Support Questions (Read Only)

Hive Query Error:java.lang.OutOfMemoryError: Java heap space

baby88 — Fri, 16 Sep 2022 09:02:02 GMT

HQL: select count(station_id) from aws_new;

Result:

1 What`s the reseaon?

2 How should I do?

Re: Hive Query Error:java.lang.OutOfMemoryError: Java heap space

Harsh J — Sun, 20 Jul 2014 14:42:34 GMT

Your local Hive CLI JVM heap size is insufficient for even building and submitting the job.

Please try raising it as below, and retrying:

~> export HADOOP_CLIENT_OPTS="-Xmx2g"
~> hive -e "select count(station_id) from aws_new;"