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. |
METASTORE_DB_NAME
|
VARCHAR(128) | The name of the database containing the metadata about the Hive database. |
Privileges
No explicit permissions are required; however, users see only the records that correspond to schemas they have permissions to access.