Oracle DBMS_HADOOP
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
DBMS_HADOOP_INTERNAL    
Documented Yes
First Available 12.2.0.1
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
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 (new 19c)
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 (new 19c)
Verifies whether a user has a given role dbms_hadoop.user_privileged(
user_role  IN VARCHAR2,
cluster_id IN VARCHAR2)
RETURN NUMBER;
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_HADOOP_INTERNAL
What's New In 18cR3
What's New In 19cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
DBSecWorx