Data Retrieval Performance Issue Using External Table For BDA Hive Partition Table
(Doc ID 1947002.1)
Last updated on APRIL 08, 2020
Applies to:Oracle SQL Connector for Hadoop Distributed File System - Version 3.0 and later
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