Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Solved
Go to solution
Hive Query Error:java.lang.OutOfMemoryError: Java heap space
Labels:
- Labels:
-
Apache Hive
Explorer
Created on 07-12-2014 05:33 AM - edited 09-16-2022 02:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HQL: select count(station_id) from aws_new;
Result:
1 What`s the reseaon?
2 How should I do?
1 ACCEPTED SOLUTION
Mentor
Created 07-20-2014 07:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;"
Please try raising it as below, and retrying:
~> export HADOOP_CLIENT_OPTS="-Xmx2g"
~> hive -e "select count(station_id) from aws_new;"
1 REPLY 1
Mentor
Created 07-20-2014 07:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;"
Please try raising it as below, and retrying:
~> export HADOOP_CLIENT_OPTS="-Xmx2g"
~> hive -e "select count(station_id) from aws_new;"
