My Oracle Support Banner

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

Last updated on NOVEMBER 08, 2022

Applies to:

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


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.


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.