DBA Data[Home] [Help]

VIEW: SYS.CDB_HIVE_COLUMNS

Source

View Text - Preformatted

SELECT "CLUSTER_ID","DATABASE_NAME","TABLE_NAME","COLUMN_NAME","HIVE_COLUMN_TYPE","ORACLE_COLUMN_TYPE","LOCATION","OWNER","CREATION_TIME","HIVE_URI","CON_ID" FROM CONTAINERS("SYS"."DBA_HIVE_COLUMNS")
View Text - HTML Formatted

SELECT "CLUSTER_ID"
, "DATABASE_NAME"
, "TABLE_NAME"
, "COLUMN_NAME"
, "HIVE_COLUMN_TYPE"
, "ORACLE_COLUMN_TYPE"
, "LOCATION"
, "OWNER"
, "CREATION_TIME"
, "HIVE_URI"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_HIVE_COLUMNS")