My Oracle Support Banner

Hive Query Fails with 'java.lang.OutOfMemoryError: GC overhead limit exceeded' (Doc ID 1928744.1)

Last updated on NOVEMBER 11, 2019

Applies to:

Big Data Appliance Integrated Software - Version 2.5.0 and later
Linux x86-64


Executing Hive query against a table with > 5Million rows from Hive Client shell fails with 'GC overhead limit exceeded' error. The same error will occur even when executing select count(*)

hive> select * from <Table_Name> limit 1;
Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded
  at java.util.Arrays.copyOf(
  at java.lang.AbstractStringBuilder.expandCapacity(
  at org.apache.hadoop.hive.cli.CliDriver.executeDriver(
  at org.apache.hadoop.hive.cli.CliDriver.main(



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.