Oracle教程 2023-02-23

Oracle 视图 ALL_HIVE_TAB_PARTITIONS 官方解释，作用，如何使用详细说明

Oracle视图ALL_HIVE_TAB_PARTITIONS用于查看Hive表上存在的分区信息，开发者可以使用该视图来获取Hive表上对应分区的分区值，包括分区名、列类型、列值等。

例如：

SELECT
*
FROM
all_hive_tab_partitions;

此查询可以获取所有Hive表上存在的分区信息，以此暴露出Hive分区设置情况。

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

Related Views

DBA_HIVE_TAB_PARTITIONS provides information about all Hive table partitions in the database.
USER_HIVE_TAB_PARTITIONS provides information about all Hive table partitions owned by the current user in the database.

Column	Datatype	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