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 laterLinux 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
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
Symptoms |
Cause |
Solution |
References |