Provides Database Connection Pooling Service for Apache Hive. Connections can be asked from pool and returned after usage.
hive, dbcp, jdbc, database, connection, pooling, store
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, whether a property supports the NiFi Expression Language, and whether a property is considered "sensitive", meaning that its value will be encrypted. Before entering a value in a sensitive property, ensure that the nifi.properties file has an entry for the property nifi.sensitive.props.key.
| Name | Default Value | Allowable Values | Description |
|---|---|---|---|
| Database Connection URL | A database connection URL used to connect to a database. May contain database system name, host, port, database name and some parameters. The exact syntax of a database connection URL is specified by the Hive documentation. For example, the server principal is often included as a connection parameter when connecting to a secure Hive server. Supports Expression Language: true (will be evaluated using variable registry only) | ||
| Hive Configuration Resources | A file or comma separated list of files which contains the Hive configuration (hive-site.xml, e.g.). Without this, Hadoop will search the classpath for a 'hive-site.xml' file or will revert to a default configuration. Note that to enable authentication with Kerberos e.g., the appropriate properties must be set in the configuration files. Please see the Hive documentation for more details. This property expects a comma-separated list of file resources. Supports Expression Language: true (will be evaluated using variable registry only) | ||
| Database User | Database user name Supports Expression Language: true (will be evaluated using variable registry only) | ||
| Password | The password for the database user Sensitive Property: true Supports Expression Language: true (will be evaluated using variable registry only) | ||
| Max Wait Time | 500 millis | The maximum amount of time that the pool will wait (when there are no available connections) for a connection to be returned before failing, or -1 to wait indefinitely. Supports Expression Language: true (will be evaluated using variable registry only) | |
| Max Total Connections | 8 | The maximum number of active connections that can be allocated from this pool at the same time, or negative for no limit. Supports Expression Language: true (will be evaluated using variable registry only) | |
| Max Connection Lifetime | -1 | The maximum lifetime in milliseconds of a connection. After this time is exceeded the connection pool will invalidate the connection. A value of zero or -1 means the connection has an infinite lifetime. Supports Expression Language: true (will be evaluated using variable registry only) | |
| Validation query | Validation query used to validate connections before returning them. When a borrowed connection is invalid, it gets dropped and a new valid connection will be returned. NOTE: Using validation may have a performance penalty. Supports Expression Language: true (will be evaluated using variable registry only) | ||
| Kerberos Credentials Service | Controller Service API: KerberosCredentialsService Implementation: KeytabCredentialsService | Specifies the Kerberos Credentials Controller Service that should be used for authenticating with Kerberos | |
| Kerberos Principal | Kerberos principal to authenticate as. Requires nifi.kerberos.krb5.file to be set in your nifi.properties Supports Expression Language: true (will be evaluated using variable registry only) | ||
| Kerberos Keytab | Kerberos keytab associated with the principal. Requires nifi.kerberos.krb5.file to be set in your nifi.properties This property requires exactly one file to be provided.. Supports Expression Language: true (will be evaluated using variable registry only) | ||
| Kerberos Password | Kerberos password associated with the principal. Sensitive Property: true |