Creating New Hive Connections

The following steps demonstrate how to create new Hive data connections.

Availability Note. This connection type provides basic connectivity and functionality for Hive Connections. However, it does not support the use of save table and data sampling features, analytical views, or flow and funnel visuals.
Create New Data Connection Modal Window: Hive
Create a New Hive Data Connection
  1. On the main navigation bar, click Data.

    Click DATA on main nav

    The Data view appears, open on the Datasets tab.

    Main landing page of DATA
  2. In the side bar, click New Connection.

    Create New Connection

    The Create New Data Connection modal window appears.

  3. In the Create New Data Connection modal window, under Connection type, select Hive.
  4. Under Connection name, specify the name of the new connection. Here, we use HiveConnection.
  5. Under Hostname or IP address, specify the name of your database host, or its IP address; use localhost when the data source is local.

  6. Under Port #, enter the port number. The default port # for Hive connections is 10000.
  7. Under Credentials, complete the following entries.

    • Under Username, enter the username for establishing the connection.

    • Under Password, enter the password for establishing the connection.

  8. Click Advanced tab.

    Advanced connection options
    Advanced Connection Options
  9. Choose Connection mode: either Binary (default), or HTTP.
  10. Choose Socket type.

    Note: Windows platforms support only normal sockets; therefore, socket options do not appear on the modal window.

    • Normal [default]

    • SSL

    • SSL with certificate

      If you select this option, you can Allow Common Name - Host Name Mismatch, which means that the issued SSL certificate name does not have to match the host name of the server. By default, the names must match.

      support for common name/host mismatch
      Support for Common Name and Host Name Mismatch
  11. Choose Authentication mode.

    Note: Windows platforms support only NoSasl authentication; therefore, authentication options do not appear on the modal window.

    Note: Kerberos authentication is only available on Linux platforms.

    • NoSasl

    • Plain

    • LDAP

    • Kerberos

  12. Specify Timeout interval. The default value is 60 seconds.

  13. Specify Session Timeout. The default value is 0, meaning that sessions do not time out.
  14. Choose Queue depth.

    This controls the maximum number of simultaneous queries on the connection.

    • By default, the value is 2 and does not have to be specified.

    • Valid values are integers 1 through 100.

  15. Click the Parameters tab.

    Parameter tabs, specifying parameter name/value
    Specifying Connection Parameters
  16. Click the first row to add a Parameter name/value pair. Type in the parameters and their values.

  17. If you want to remove a parameter, click (trash can) icon to remove existing parameters.

  18. Click the Cache tab.

    Cache tab, specifying Result Cache Enable and Retention Time options
    Specifying Cache
  19. Select the Result Cache option to enable periodic cache updates.

  20. In the Retention Time field, specify the frequency of cache updates, in seconds.

    For example, the default value of 86400 indicates an update every 24 hours, and a value of 300 initiates a refresh every 5 minutes.

  21. At the bottom of the modal, click Test.

    testing connection
    Testing the New Connection

    If the connection is valid, the system returns a 'Connection Verified' message.

  22. Click Save.

    connection verified, connecting
    Connecting a Verified Connection

After this operation succeeds, the new connection name appears on the side navigation bar.