2.159 ALL_HIVE_COLUMNS

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

Related Views

  • DBA_HIVE_COLUMNS describes all Hive columns in a Hive metastore.

  • USER_HIVE_COLUMNS describes all Hive columns owned by 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

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).