ImpalaConnectionPool

Description:

Provides Impala Connection Pooling Service with built-in JDBC driver. Connections can be requested from the pool and returned once they have been used.

Tags:

impala, dbcp, jdbc, database, connection, pooling, store

Properties:

In the list below, the names of required properties appear in bold. Any other properties (not in bold) are considered optional. The table also indicates any default values, and whether a property supports the NiFi Expression Language.

Display NameAPI NameDefault ValueAllowable ValuesDescription
Driver Versiondriver-version2.6.32.1041
  • 2.6.32.1041
Driver version to be used for connecting to Impala. Only serves informational purposes.
Database Hostnamedatabase-hostnameThe hostname of the database to connect.
Supports Expression Language: true (will be evaluated using variable registry only)
Database Portdatabase-port21050The port of the database to connect.
Supports Expression Language: true (will be evaluated using variable registry only)
Schema Nameschema-nameThe name of the schema to connect.
Supports Expression Language: true (will be evaluated using variable registry only)
Transport ModetransportModeBinary
  • Binary The connector uses the Binary transport protocol [transportMode=binary]. Supportsanonymous (AuthMech=0), and Username and Password (AuthMech=3) authentication.
  • SASL The connector uses the SASL transport protocol [transportMode=sasl]. Does not support anonymous (AuthMech=0) authentication.
  • HTTP The connector uses the HTTP transport protocol [transportMode=http]. Supports anonymous(AuthMech=0), and Username and Password (AuthMech=3) authentication.
The transport protocol to use in the Thrift layer. (sets the 'transportMode' property)
HTTP PathhttpPathcliserviceThe partial URL corresponding to the Impala server. The connector forms the HTTP address to connect to by appending this value to the host and port specified in the connection URL. (sets the 'httpPath' property)
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Transport Mode] Property has a value of "HTTP".
Authentication MechanismAuthMechUsername and Password
  • No Authentication Access Impala anonymously [AuthMech=0]. Not compatible with SASL transport mode.
  • Kerberos Use a Kerberos credential to access Impala [AuthMech=1]. Compatible with SASL transport mode.
  • Username Only Use a username, without password to access Impala [AuthMech=2]. The username labels the session only, facilitating database tracking. Compatible with SASL transport mode.
  • Username and Password Use a username and password pair to access Impala [AuthMech=3]. It is most commonly used with LDAP authentication. Compatible with all transport modes.
The authentication mechanism to use with Impala. (sets the 'AuthMech' property)
UsernameUIDanonymousDatabase user name
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Authentication Mechanism] Property is set to one of the following values: [Username Only], [Username and Password]
PasswordPWDThe password for the database user
Sensitive Property: true
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Authentication Mechanism] Property has a value of "Username and Password".
Kerberos User Servicekerberos-user-serviceController Service API:
KerberosUserService
Implementations: KerberosTicketCacheUserService
KerberosKeytabUserService
KerberosPasswordUserService		Specifies the Kerberos User Controller Service that should be used for authenticating with Kerberos

This Property is only considered if the [Authentication Mechanism] Property has a value of "Kerberos".
Kerberos Host FQDNKrbHostFQDNThe fully qualified domain name of the Impala host. Defaults to 'Database Hostname'.
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Authentication Mechanism] Property has a value of "Kerberos".
Kerberos RealmKrbRealmThe realm of the Impala host. If your Kerberos configuration already defines the realm of the Impala host as the default realm, then you do not need to configure this property.
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Authentication Mechanism] Property has a value of "Kerberos".
Kerberos Service NameKrbServiceNameimpalaThe Kerberos service principal name of the Impala server.
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Authentication Mechanism] Property has a value of "Kerberos".
SSL Context ServiceSSL Context ServiceController Service API:
SSLContextService
Implementations: StandardRestrictedSSLContextService
StandardSSLContextService		If specified, indicates the SSL Context Service that is used to communicate with the remote server. If not specified, communications will not be encrypted

Dynamic Properties:

Supports Sensitive Dynamic Properties: Yes

Dynamic Properties allow the user to specify both the name and value of a property.

NameValueDescription
JDBC property nameJDBC property valueJDBC driver property name and value applied to JDBC connections.
Supports Expression Language: true (will be evaluated using variable registry only)

State management:

This component does not store state.

Restricted:

This component is not restricted.

System Resource Considerations:

None specified.