Hive Query with Order By and Limit Clause Fails with java.lang.java.lang.OutOfMemoryError

(Doc ID 2101264.1)

Last updated on JUNE 30, 2017

Applies to:

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

Symptoms

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

 If the LIMIT is removed the query will complete successfully.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms