HCATALOG_TABLES
Returns a detailed list of all tables made available through the HCatalog Connector.
Returns a detailed list of all tables made available through the HCatalog Connector. See Using the HCatalog Connector.
| Column Name | Data Type | Description |
|---|---|---|
TABLE_SCHEMA_ID |
INTEGER | ID number of the schema |
TABLE_SCHEMA |
VARCHAR(128) | The name of the Vertica Analytic Database schema through which the table is available |
HCATALOG_SCHEMA |
VARCHAR(128) | The name of the Hive schema or database that contains the table |
TABLE_NAME |
VARCHAR(128) | The name of the table |
HCATALOG_USER_NAME |
VARCHAR(128) | The name of the HCatalog user whose credentials are used to access the table's data |
MIN_FILE_SIZE_BYTES |
INTEGER | The file size of the table's smallest data file, if using WebHCat; null if using HiveServer2 |
TOTAL_NUMBER_FILES |
INTEGER | The number of files used to store this table's data in HDFS |
LOCATION |
VARCHAR(8192) | The URI for the directory containing this table's data, normally an HDFS URI |
LAST_UPDATE_TIME |
TIMESTAMPTZ | The last time data in this table was updated, if using WebHCat; null if using HiveServer2 |
OUTPUT_FORMAT |
VARCHAR(128) | The Hive SerDe class used to output data from this table |
LAST_ACCESS_TIME |
TIMESTAMPTZ | The last time data in this table was accessed, if using WebHCat; null if using HiveServer2 |
MAX_FILE_SIZE_BYTES |
INTEGER | The size of the largest data file for this table, if using WebHCat; null if using HiveServer2 |
IS_PARTITIONED |
BOOLEAN | Whether this table is partitioned |
PARTITION_EXPRESSION |
VARCHAR(128) | The expression used to partition this table |
TABLE_OWNER |
VARCHAR(128) | The Hive user that owns this table in the Hive database, if using WebHCat; null if using HiveServer2 |
INPUT_FORMAT |
VARCHAR(128) | The SerDe class used to read the data from this table |
TOTAL_FILE_SIZE_BYTES |
INTEGER | Total number of bytes used by all of this table's data files |
HCATALOG_GROUP |
VARCHAR(128) | The permission group assigned to this table, if using WebHCat; null if using HiveServer2 |
PERMISSION |
VARCHAR(128) |
The Unix file permissions for this group, as shown by the ls -l command, if using WebHCat; null if using HiveServer2 |
Privileges
No explicit permissions are required; however, users see only the records that correspond to schemas they have permissions to access.