The following steps demonstrate how to edit existing data connections. Here, we will change an Impala connection to a Hive connection.
On the main navigation bar, click Data.
The Data view appears, open on the Datasets tab.
In the side bar, click (Edit) to the right of ImpalaConnection.
The Edit Data Connection modal window appears.
HiveConnection
.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.
10000
, the default port # for Hive connections.Under Credentials, complete the following entries.
Under Username, enter the username for establishing the connection.
Under Password, enter the password for establishing the connection.
Click Advanced tab.
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
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.
Specify Timeout interval. The default value is 60
seconds.
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
.
At the bottom of the modal, click Test.
If the connection is valid, the system returns a 'Connection Verified' message.
Click Save.
After this operation succeeds, the new name of the connection appears on the side navigation bar.