Hive Metastore Connection

The Hive Metastore connection type enables the Hive Metastore Integrations.

Authenticating to Hive Metastore

Authentication with the Hive Metastore through Apache Thrift Hive Server and the hmsclient.

Default Connection IDs

All hooks and operators related to the Hive Metastore use metastore_default by default.

Configuring the Connection

Host (optional)

The host of your Hive Metastore node. It is possible to specify multiple hosts as a comma-separated list.

Port (optional)

Your Hive Metastore port number.

Extra (optional)

Specify the extra parameters (as json dictionary) that can be used in Hive Metastore connection. The following parameters are all optional:

  • auth_mechanism Specify the mechanism for authentication. Default is NOSASL.

  • kerberos_service_name Specify the kerberos service name. Default is hive.

When specifying the connection in environment variable you should specify it using URI syntax.

Note that all components of the URI should be URL-encoded.

For example:

export AIRFLOW_CONN_METASTORE_DEFAULT='hive-metastore://hive-metastore-node:80?auth_mechanism=NOSASL'

Was this entry helpful?