HIVE_CUSTOM_PARTITIONS_ACCESSED
This table provides information about all custom locations for Hive partition data that OpenText™ Analytics Database has accessed.
This table provides information about all custom locations for Hive partition data that OpenText™ Analytics Database 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 the database 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.