"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible.
I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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);