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

[#1]

HQL: select count(station_id) from aws_new;

Result:

1  What`s the reseaon?

2  How should I do?

[#2 · Accepted solution]

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;"