ALL_HIVE_COLUMNS

ALL_HIVE_COLUMNS describes all Hive columns accessible to the current user in a Hive metastore.

Column Datatype NULL Description
CLUSTER_ID VARCHAR2(4000)   Identifier for the Hadoop cluster
DATABASE_NAME VARCHAR2(4000)   Hive database where the owning Hive table resides
TABLE_NAME VARCHAR2(4000)   Hive table name that the column belongs to
COLUMN_NAME VARCHAR2(4000)   Hive column name
HIVE_COLUMN_TYPE VARCHAR2(4000)   Data type of the Hive column
ORACLE_COLUMN_TYPE VARCHAR2(4000)   Equivalent Oracle data type of the Hive column
LOCATION VARCHAR2(4000)   Physical location of the Hive table
OWNER VARCHAR2(4000)   Owner of the Hive table
CREATION_TIME DATE   Time that the Hive column was created
HIVE_URI VARCHAR2(4000)   The connection string (URI and port number) for the metastore database

See Also: