HCATALOG_SCHEMATA
Lists all of the schemas defined using the HCatalog Connector. See Using the HCatalog Connector in Integrating with Apache Hadoop.
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.