Catalog and Schema Support

The Simba Apache Hive JDBC Connector supports both catalogs and schemas to make it easy for the connector to work with various JDBC applications. Since Hive only organizes tables into schemas/databases, the connector provides a synthetic catalog named HIVE under which all of the schemas/databases are organized. The connector also maps the JDBC schema to the Hive schema/database.

Note:

The synthetic SPARK catalog only applies to servers that do not support multiple catalogs. For servers that do, the connector returns their catalogs as is.
Setting the CatalogSchemaSwitch connection property to 1 will cause Hive catalogs to be treated as schemas in the connector as a restriction for filtering.