Editing Data Connections

The following steps demonstrate how to edit existing data connections. Here, we will change an Impala connection to a Hive connection.

  1. On the main navigation bar, click Data.

    The Data view appears, open on the Datasets tab.

  2. In the side bar, click (Edit) to the right of ImpalaConnection.

    The Edit Data Connection modal window appears.

    Edit Data Connection Modal Window: initial
    Editing a Data Connection
  3. In the Edit Data Connection modal window, choose Connection type Hive.
  4. Under Connection name, specify the new name of the connection. Here, use HiveConnection.
  5. Under Hostname or IP address, enter 20.0.1.20.

    You can 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. Here, we used 10000, the default port # for Hive connections.
  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 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

  10. Choose Authentication mode.

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

    • NoSasl

    • Plain

    • LDAP

    • Kerberos

      Note: Kerberos authentication is only available on Linux platforms.

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

  12. 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.

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

    testing connection.
    Testing the New Connection
  14. If the connection is valid, the system returns a 'Connection Verified' message.

    connection verified.
    New Connection Verified
  15. Click Save.

    Edit Data Connection Modal Window: final
    Edited Data Connection Information

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