ALL_HIVE_TAB_PARTITIONS

ALL_HIVE_TAB_PARTITIONS provides information about all Hive table partitions accessible to the current user in the database.

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 partition
OWNER VARCHAR2(4000)   Owner of the Hive table
PARTITION_SPECS VARCHAR2(4000)   The current Hive partition specification
PART_SIZE NUMBER   Partition size in bytes
CREATION_TIME DATE   Time that the partition was created

See Also: