My Oracle Support Banner

Hive Query with Order By and Limit Clause Fails with java.lang.java.lang.OutOfMemoryError (Doc ID 2101264.1)

Last updated on NOVEMBER 08, 2022

Applies to:

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

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.Also note that  "sample_07" is a part of the CDH distribution on the BDA.

Hive queries with an ORDER BY and LIMIT clause causes OutOfMemoryError.  For example:

 If the LIMIT is removed the query will complete successfully.

Cause

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
Symptoms
Cause
Solution


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