Data Retrieval Performance Issue Using External Table For BDA Hive Partition Table (Doc ID 1947002.1)

Last updated on NOVEMBER 24, 2014

Applies to:

Oracle SQL Connector for Hadoop Distributed File System - Version 3.0 and later
Linux x86-64

Symptoms

A performance degradation is observed with additional UNION ALL clauses in a CREATE TABLE statement on an external table in Oracle DB 11g. (No performance degradation is observed without UNION ALL.) No such performance degradation is observed in Oracle DB 12c.

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