prepared for the release of Oracle Database
18c ... the first autonomous database? We are here at the Library. It is
time for DBAs to stop fighting robots with their fingers and losing ...
time to start using our intelligence and winning.
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.
Owned by SYS with EXECUTE granted to PUBLIC
This file is restricted to only run, during installation, on the Linux
Given a hive table name, creates a text of DDL that can be executed to create an external table corresponding to the hive table
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);