Oracle | DBMS

Oracle DBMS_HADOOP Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Provides a PL/SQL procedure called CREATE_EXTDDL_FOR_HIVE(), that creates an Oracle external table for a given hive table. Big Data SQL needs to be correctly set up for DBMS_HADOOP to work.

AUTHID CURRENT_USER

Dependencies

ALL_HIVE_COLUMNS	DBMS_PRIV_CAPTURE
ALL_HIVE_DATABASES	DBMS_SESSION
ALL_HIVE_PART_KEY_COLUMNS	DBMS_SQL
ALL_HIVE_TABLES	DBMS_STANDARD
ALL_HIVE_TAB_PARTITIONS	ROLE_TAB_PRIVS
ALL_XT_HIVE_TABLES_VALIDATION	USER_HIVE_COLUMNS
DBMS_ASSERT	USER_HIVE_DATABASES
DBMS_HADOOP_INTERNAL	USER_HIVE_PART_KEY_COLUMNS
DBMS_ISCHED	USER_HIVE_TABLES
DBMS_METADATA	USER_HIVE_TAB_PARTITIONS
DBMS_OUTPUT	USER_XT_HIVE_TABLES_VALIDATION

Documented Yes: Packages and Types Reference

First Available 12.2

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmshadp1.sql

This file is only run during installation on the Linux O/S.

Subprograms

CREATE_EXTDDL_FOR_HIVE	SYNC_PARTITIONS_FOR_HIVE	USER_PRIVILEGED
CREATE_HYBRID_PARTNED_TABLE

CREATE_EXTDDL_FOR_HIVE

Given a hive table name, creates a text of DDL that can be executed to create an external table corresponding to the hive table dbms_hadoop.create_extddl_for_hive( cluster_id IN VARCHAR2, db_name IN VARCHAR2, hive_table_name IN VARCHAR2, hive_partition IN BOOLEAN, table_name IN VARCHAR2, perform_ddl IN BOOLEAN, text_of_ddl OUT CLOB);

TBD

CREATE_HYBRID_PARTNED_TABLE

Given a LIST partitioned local Oracle table and a (list) partitioned Hive table, merge the Hive partitions into the Oracle table. The Oracle table now becomes a hybrid partitioned table. dbms_hadoop.create_hybrid_partned_table( cluster_id IN VARCHAR2, db_name IN VARCHAR2, hive_table_name IN VARCHAR2, table_name IN VARCHAR2, perform_ddl IN BOOLEAN := FALSE, text_of_ddl OUT CLOB);

TBD

SYNC_PARTITIONS_FOR_HIVE

Synchronizes the existing partitioning definition of a hive table in Oracle catalog dbms_hadoop.sync_partitions_for_hive( xt_tab_name IN VARCHAR2, xt_tab_owner IN VARCHAR2);

TBD

USER_PRIVILEGED

Verifies whether a user has a given role dbms_hadoop.user_privileged( user_role IN VARCHAR2, cluster_id IN VARCHAR2) RETURN NUMBER;

TBD