Data Retrieval Performance Issue Using External Table For BDA Hive Partition Table
Last updated on NOVEMBER 24, 2014
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.
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