DBA Data[Home] [Help]
Skip to content

VIEW: SYS.ALL_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" FROM USER_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"
FROM USER_HIVE_COLUMNS