My Oracle Support Banner

Ore.pull Results in Hive Out Of Memory Error (Doc ID 2282916.1)

Last updated on APRIL 08, 2020

Applies to:

Oracle R Connector for Hadoop - Version 2.7.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.

Returning data from a hive table to Oracle R fails with an out of memory exception:

> <TEST_TABLE> <-ore.pull(<TABLE>)
org.apache.thrift.TException: Error in calling method FetchResults
...
Caused by: java.lang.OutOfMemoryError: Java heap space
...
Error: HIVE command failed with: 'java.sql.SQLException: Error retrieving next row'
In addition: Warning message:
ORE object has no unique key - using random order

 

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.