2.169 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 |
---|---|---|---|
|
|
|
Hadoop cluster name |
|
|
|
Hive database where the Hive table resides |
|
|
|
Hive table name |
|
|
|
Physical location of the Hive table |
|
|
|
Number of columns in the Hive table |
|
|
|
Creation time of the Hive table |
|
|
|
Time that the Hive table was last accessed |
|
|
|
Owner of the Hive table |
|
|
|
Type of the Hive table |
|
|
|
Is this Hive table partitioned? |
|
|
|
Number of partition keys in the Hive table |
|
|
|
Hive table input format |
|
|
|
Hive table output format |
|
|
|
Hive table serialization |
|
|
|
Is this Hive table compressed? |
|
|
|
The connection string (URI and port number) for the metastore database |
See Also: