For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
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 only run during installation on the Linux O/S.
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);