VIEW: SYS.DBA_HIVE_DATABASES

Source

View Text - Preformatted

SELECT UNIQUE HT.C15 AS CLUSTER_ID,
       HT.C0 AS DATABASE_NAME,
       HT.C4 AS DESCRIPTION,
       HT.C5 AS DB_LOCATION,
       HT.C16 AS HIVE_URI
    FROM
    (SELECT DIRECTORY_PATH AS configDir
     FROM DBA_DIRECTORIES
     WHERE UPPER(DIRECTORY_NAME) = 'ORACLE_BIGDATA_CONFIG') HU,
    (SELECT DIRECTORY_PATH AS debugDir
     FROM DBA_DIRECTORIES
     WHERE UPPER(DIRECTORY_NAME) = 'ORACLE_BIGDATA_DEBUG'
           AND (DBMS_HADOOP_INTERNAL.DEBUG_USER_PRIVILEGED('SYS') = 1)
     UNION ALL
     SELECT 'InvalidDir' FROM DUAL WHERE
           NOT EXISTS (SELECT DIRECTORY_PATH AS debugDir
                       FROM DBA_DIRECTORIES
                       WHERE UPPER(DIRECTORY_NAME) = 'ORACLE_BIGDATA_DEBUG'
                             AND (DBMS_HADOOP_INTERNAL.DEBUG_USER_PRIVILEGED('SYS') = 1))
    ) HV,
     LATERAL(SELECT * FROM TABLE(DBMS_HADOOP_INTERNAL.GetHiveTable(LPAD(TO_CHAR(LENGTH(HU.configDir)),8,0)
                                 || HU.configDir || ';' || HV.debugDir, '*', '*', '*', 'TRUE', 0))) HT

View Text - HTML Formatted

SELECT UNIQUE HT.C15 AS CLUSTER_ID
, HT.C0 AS DATABASE_NAME
, HT.C4 AS DESCRIPTION
, HT.C5 AS DB_LOCATION
, HT.C16 AS HIVE_URI FROM (SELECT DIRECTORY_PATH AS CONFIGDIR
FROM DBA_DIRECTORIES
WHERE UPPER(DIRECTORY_NAME) = 'ORACLE_BIGDATA_CONFIG') HU
, (SELECT DIRECTORY_PATH AS DEBUGDIR
FROM DBA_DIRECTORIES
WHERE UPPER(DIRECTORY_NAME) = 'ORACLE_BIGDATA_DEBUG'
AND (DBMS_HADOOP_INTERNAL.DEBUG_USER_PRIVILEGED('SYS') = 1) UNION ALL SELECT 'INVALIDDIR'
FROM DUAL WHERE NOT EXISTS (SELECT DIRECTORY_PATH AS DEBUGDIR
FROM DBA_DIRECTORIES
WHERE UPPER(DIRECTORY_NAME) = 'ORACLE_BIGDATA_DEBUG'
AND (DBMS_HADOOP_INTERNAL.DEBUG_USER_PRIVILEGED('SYS') = 1)) ) HV
, LATERAL(SELECT *
FROM TABLE(DBMS_HADOOP_INTERNAL.GETHIVETABLE(LPAD(TO_CHAR(LENGTH(HU.CONFIGDIR))
, 8
, 0) || HU.CONFIGDIR || ';' || HV.DEBUGDIR
, '*'
, '*'
, '*'
, 'TRUE'
, 0))) HT