Details on Cloudera Impala Connection

This dialog is used to configure a connection to a Cloudera Impala database. You can choose whether to analyze data in-database or to import it into your analysis. Note that you need to install a driver on your computer to get access to the Cloudera Impala connector. See the system requirements at http://spotfi.re/sr/connectors to find the correct driver. You can also view Getting Started with Connectors to learn more about getting access to connectors in Spotfire.

To add a new Cloudera Impala connection to the library:

On the menu bar, select Data > Manage Data Connections.
Click Add New > Data Connection and select Cloudera Impala.

To add a new Cloudera Impala connection to an analysis:

Click Files and data .
In the Files and data flyout, click Connect to.
In the list of connectors, click Cloudera Impala.
In the Cloudera Impala flyout, click New connection.

Option	Description
Server	The name of the server where your data is located. To include a port number, add it directly after the name preceded by colon. The default port is 25010. Example with port number: MyDatabaseServer:25010
Authentication method	The authentication method to use when logging into the database. Choose from No authentication Kerberos authentication Username authentication Username and password authentication
Realm	[Only applicable when Kerberos authentication is selected.] The Kerberos realm of the Impala server host. Leave blank if a default Kerberos realm has been configured for your Kerberos setup. For more information about the realm, contact your Cloudera Impala system administrator.
Host FQDN	[Only applicable when Kerberos authentication is selected.] The fully qualified domain name of the Impala host. For more information about the service name, contact your Cloudera Impala system administrator.
Service name	[Only applicable when Kerberos authentication is selected.] The service name of the Impala server. For example, "impala". For more information about the service name, contact your Cloudera Impala system administrator.
Username	The username you wish to use when logging into Cloudera Impala.
Password	The password for the specified username.
Use secure sockets layer (SSL)	Select this check box to connect using SSL.
Use simple authentication and security layer (SASL)	Select this check box to connect using SASL. Note: If you select the Transport mode option HTTP on the Advanced tab, that option takes precedence over your selection for SASL. You cannot use both SASL and Transport mode HTTP at the same time.
Connect	Connects you to the specified server and populates the list of available databases below.
Database	Select the database of interest from the drop-down list.

Advanced

Option	Description
Connection timeout (s)	Specify the maximum number of seconds allowed for a connection to the database to be established. The default value is 120. Note: If you set the connection timeout to zero, it will be interpreted as no timeout. That is, there will be no upper limit for trying to connect. This is generally not recommended.
Command timeout (s)	Specify the maximum number of seconds allowed for a command to be executed. The default value is 1800. Note: If you set the command timeout to zero, it will be interpreted as no timeout. That is, there will be no upper limit for trying to execute the command. This is generally not recommended.
Transport mode	Select the thrift transport mode to use in the thrift layer when connecting to the data source. The following options are available: Binary Binary is the default transport mode. Binary is in use if you do not select either Use simple authentication and security layer (SASL) on the General tab, or transport mode HTTP. Note: If you have selected the option Use simple authentication and security layer (SASL), that option takes precedence over the Transport mode option Binary. HTTP The transport mode HTTP is often required when a proxy is used between client and server, for example for load balancing. When you select HTTP, you must also configure the HTTP Path. Note: If you select HTTP, this option takes precedence over the option Use simple authentication and security layer (SASL).
HTTP Path	Specify the partial URL that corresponds to the Impala server you are connecting to. The partial URL is appended to the host and port specified in the Server field. Together, they form the full address. As an example, say you want to connect to the address https://example.com:21050/gateway/sandbox/impala/version. Then for Server, enter https://example.com:21050. And for HTTP Path, enter /gateway/sandbox/impala/version.