HCATALOG_SCHEMATA
Lists all of the schemas defined using the HCatalog Connector.
Lists all of the schemas defined using the HCatalog Connector. See Using the HCatalog Connector.
Unlike other HCatalog Connector-related system tables, this table makes no calls to Hive, so querying incurs very little overhead.
| Column Name | Data Type | Description |
|---|---|---|
SCHEMA_ID |
INTEGER | The Vertica Analytic Database ID number for the schema |
SCHEMA_NAME |
VARCHAR(128) | The name of the schema defined in the Vertica Analytic Database catalog |
SCHEMA_OWNER_ID |
INTEGER | The ID number of the user who owns the Vertica Analytic Database schema |
SCHEMA_OWNER |
VARCHAR(128) | The username of the Vertica Analytic Database schema's owner |
CREATE_TIME |
TIMESTAMPTZ | The date and time the schema as created |
HOSTNAME |
VARCHAR(128) | The host name or IP address of the database server that holds the Hive metadata |
PORT |
INTEGER | The port number on which the metastore database listens for connections |
HIVESERVER2_HOSTNAME |
VARCHAR(128) | The host name or IP address of the HiveServer2 server for the Hive database |
WEBSERVICE_HOSTNAME |
VARCHAR(128) | The host name or IP address of the WebHCat server for the Hive database, if used |
WEBSERVICE_PORT |
INTEGER | The port number on which the WebHCat server listens for connections |
WEBHDFS_ADDRESS |
VARCHAR (128) | The host and port ("host:port") for the WebHDFS service, used for reading ORC and Parquet files |
HCATALOG_SCHEMA_NAME |
VARCHAR(128) | The name of the schema or database in Hive to which the Vertica Analytic Database schema is mapped/ |
HCATALOG_USER_NAME |
VARCHAR(128) | The username the HCatalog Connector uses to authenticate itself to the Hive database. |
HCATALOG_CONNECTION_TIMEOUT |
INTEGER | The number of seconds the HCatalog Connector waits for a successful connection to the HiveServer or WebHCat server. A value of 0 means wait indefinitely. |
HCATALOG_SLOW_TRANSFER_LIMIT |
INTEGER | The lowest data transfer rate (in bytes per second) from the HiveServer2 or WebHCat server that the HCatalog Connector accepts. |
HCATALOG_SLOW_TRANSFER_TIME |
INTEGER | The number of seconds the HCatalog Connector waits before enforcing the data transfer rate lower limit by breaking the connection and terminating the query. |
SSL_CONFIG |
VARCHAR(128) | The path of the Hadoop ssl-client.xml configuration file, if using HiveServer2 with SSL wire encryption. |
CUSTOM_PARTITIONS |
BOOLEAN | Whether the Hive schema uses custom partition locations. |
Privileges
No explicit permissions are required; however, users see only the records that correspond to schemas they have permissions to access.