HIVE_CUSTOM_PARTITIONS_ACCESSED

This table provides information about all custom locations for Hive partition data that Vertica has 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.