Connecting a Hive Database

Connect to Hive

Here is what you need to connect:

  • Database connection information
  • Credentials

Create a Hive Datasource in bipp

  1. Select Datasources from the Home Navigation pane to open the Datasources page.

    Datasource Page

  2. Click New Datasource on the Datasources page.

    New Datasource

  3. Enter a Name. For example, TestHive.

  4. Select Hive for SQL Dialect for your database. bipp creates and enforces the rules for the selected dialect.


  5. Enter the information for your Hive database instance:

    • Host: name or IP address of the database host.
    • Port: port on the host for the connection.
    • AuthMech: authentication mechanism to use for the connection:
      • none: no authentication.
      • plain: enter your plain Username and Password.
      • LDAP: enter your LDAP Username and Password if your organization has set up LDAP directory authentication.
    • DbName: name of the database for the connection.
  6. Click Test to verify the datasource connectivity. If you have an error, fix the connection or credentials problem and click Test again.

  7. Click Create to add the datasource.

Congratulations! You have successfully created a Hive datasource in bipp.