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



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



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.