Steps to prepare and connect to Hive

Lightup account setup

Lightup needs a user account with SELECT privileges on all data objects that you want Lightup to see. Hive handles authorization separately from authentication, and no explicit DDL granting of privileges is needed.

Authentication settings

You may need some settings from the authentication/identity service your Hive database uses. Lightup supports three types of Hive authentication: No Auth, Kerberos, and LDAP.

Connector setting

  • Auth Type - Specify No Auth, Kerberos, or LDAP (whichever your Hive database is set up to use).
    • No Auth - No identity service is used. Lightup credentials are passed directly to the database.
    • Kerberos - Use a Kerberos key pair/ticketing service. You may be prompted to enter information, especially if it's the first time you're connecting Lightup.
    • LDAP - Use an LDAP directory service to handle connections. You'll need to set up the Lightup user in LDAP. Use the same name and password as for the database user.
  • Hive Host - Enter the IP address and port for the Hive host.

LDAP-only settings

  • Username - Enter the name of the Lightup LDAP user.
  • Password - Enter the password for the account you created for Lightup.

Kerberos-only settings

You can find the values for the following settings in your /etc/hosts and /etc/krb5.conf files.

  • Hive Master Node Hostname
  • Hive Cluster Realm
  • Hive Master Node Domains
  • Kerberos Authentication Server IP
  • Kerberos Authentication Server Hostname
  • Kerberos Authentication Server Realm
  • Kerberos Authentication Server Domains
  • Kerberos Principal (for information about this setting, see hive.server2.authentication.kerberos.principal)
  • BASE64-Encoded Kerberos Keytab File (for information about this setting, see hive.server2.authentication.kerberos.keytab)

Schema scan frequency

You can adjust how often scans run for a datasource.

  • In section 3 - Advanced, select a value for Schema scan frequency: Hourly, Daily, or Weekly.

Query governance

Hive datasources support the Query history, Scheduling, and Enable data storage settings. For steps, see Set query governance settings for a datasource.