HIVE_CUSTOM_PARTITIONS_ACCESSED

This table provides information about all custom locations for Hive partition data that Vertica has accessed. It applies when Hive uses a non-default location for partition data, the HCatalog Connector is used to access that data, and the CREATE HCATALOG SCHEMA statement for the schema sets the CUSTOM_PARTITIONS parameter.

Column Name	Data Type	Description
ACCESS_TIME	TIMESTAMPTZ	Time when Vertica accessed the partition data.
ACCESS_NODE	VARCHAR(128)	Name of the node that performed the access.
TRANSACTION_ID	INTEGER	Identifier for the query that produced the access.
FILESYSTEM	VARCHAR(128)	File system of the partition data. This value is the scheme portion of the URL.
AUTHORITY	VARCHAR(128)	If the file system is HDFS, this value is the nameservice. If the file system is S3, it is the name of the bucket.
URL	VARCHAR(6400)	Full path to the partition.

Privileges

No explicit permissions are required; however, users see only the records that correspond to schemas they have permissions to access.