How to Bypass the CSV Export Limits via the Hive and Impala Editor in Hue on BDA (Doc ID 2097531.1)

Last updated on JANUARY 15, 2016

Applies to:

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

Symptoms

Exporting the result set from a select * query or select column query via Hive and Impala editors through Hue to a CSV file, the CSV file only contains a maximum of 1.000.000 rows while the full result set is expected to be more than that.

From this observation, the question arises, is there limit on the CSV and XLS export from Hive and Impala through Hue? And if there is, is the limit configurable?

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