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.