2.166 ALL_HIVE_TABLES

ALL_HIVE_TABLES provides information about all the Hive tables accessible to the current user in the Hive metastore.

Related Views

• DBA_HIVE_TABLES provides information about all Hive tables in the Hive metastore.

• USER_HIVE_TABLES provides information about all Hive tables owned by the current user in the Hive metastore.

Column	Datatype	NULL	Description
CLUSTER_ID	VARCHAR2(4000)		Hadoop cluster name
DATABASE_NAME	VARCHAR2(4000)		Hive database where the Hive table resides
TABLE_NAME	VARCHAR2(4000)		Hive table name
LOCATION	VARCHAR2(4000)		Physical location of the Hive table
NO_OF_COLS	NUMBER		Number of columns in the Hive table
CREATION_TIME	DATE		Creation time of the Hive table
LAST_ACCESSED_TIME	DATE		Time that the Hive table was last accessed
OWNER	VARCHAR2(4000)		Owner of the Hive table
TABLE_TYPE	VARCHAR2(4000)		Type of the Hive table
PARTITIONED	VARCHAR2(4000)		Is this Hive table partitioned?
NO_OF_PART_KEYS	NUMBER		Number of partition keys in the Hive table
INPUT_FORMAT	VARCHAR2(4000)		Hive table input format
OUTPUT_FORMAT	VARCHAR2(4000)		Hive table output format
SERIALIZATION	VARCHAR2(4000)		Hive table serialization
COMPRESSED	NUMBER		Is this Hive table compressed?
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).

See Also:

• "DBA_HIVE_TABLES"

• "USER_HIVE_TABLES"