...
The contents of the menus in the menu bar may change depending on which configuration type that has been opened in the currently active tab. The Data Hub profile uses the standard menu items and buttons that are visible for all configurations, and these are described in Build View.
Impala Tab
The impala Impala tab contains connections connection settings for the Impala database.
...
| Setting | Description | |||||
|---|---|---|---|---|---|---|
| Host | Enter the hostname or the IP address of the Impala database. | |||||
| Port | Enter the port number that is configured for the connection into the Impala database. | |||||
| Enable TLS | Allows the user to enable the TLS functionality for the connection to the Impala database. | |||||
| Allow Self Signed Cert | Checkbox to enable the usage of Self Signed Certificates. If this checkbox is selected, both Trust Store File Path and Trust Store Password will be disabled. | |||||
| Trust Store File Path | Enter the location of the trust store file. This path is used to store certificates from other Certified Authorities. The setup is required to establish a successful connection at the client side.
| |||||
| Trust Store Password | Enter the passphrase of the trust store file. This password is used to access the certificates stored in the trust store.
| |||||
| Key Store File Path | Enter the location of the key store file. This path is used to store your credential. This is required when setting up the server side on the SSL.
| |||||
| Key Store Password | Enter the passphrase of the key store file. This password is used to access the credentials stored in the key store.
| |||||
| Database Name | Click the Refresh button next to Database Name to retrieve a list of available database databases and then select a database from the drop-down menu. The Tables Mapping tab will appear. | |||||
| Refresh | Click this to retrieve a list of available databases. | |||||
| Test Connection | Click to test the JDBC connection to the Impala database. |
...
| Note | ||
|---|---|---|
| ||
Due to the behavior of the Kerberos JVM, Data Hub profiles and agents that will interface with a Kerberos-enabled Cloudera must be configured to run on the same EC. |
...
| Info | ||
|---|---|---|
| ||
You will need to ensure the .keytab file is located in the same host as the EC that will be running the workflow with the Data Hub agent. |
...
When the UDR fields do not have names that matches match the database columns, you can map these manually by clicking the corresponding cell and selecting the field from a drop-down list.
...
| Impala Type | Impala Range | Ultra Type | Ultra Range |
|---|---|---|---|
| STRING | Maximum of 32,767 bytes | string | Unlimited |
| INT | -2147483648 to +2147483647 | int | -2,147,483,648 to +2,147,483,647 |
| short | -32,768 to +32,767 | ||
| byte | -128 to +127 | ||
| FLOAT | 1.40129846432481707e-45 to 3.40282346638528860e+38 (positive or negative) | float | 1.40129846432481707e-45 to 3.40282346638528860e+38 (positive or negative) |
| DOUBLE | 4.94065645841246544e-324d to 1.79769313486231570e+308 (positive or negative) | double | 4.94065645841246544e-324d to 1.79769313486231570e+308d (positive or negative) |
| float | 1.40129846432481707e-45 to 3.40282346638528860e+38 (positive or negative) | ||
| BOOLEAN | TRUE or FALSE | boolean | true or false |
| BIGINT | -9223372036854775808 to +9223372036854775807 | long | -9223372036854775808 to +9223372036854775807 |
| int | -2,147,483,648 to +2,147,483,647 | ||
| short | -32,768 to +32,767 | ||
| byte | -128 to +127 | ||
| REAL | 4.94065645841246544e-324d to +1.79769313486231570e+308 (positive or negative) | double | 4.94065645841246544e-324d to 1.79769313486231570e+308d (positive or negative) |
| SMALLINT | -32768 to +32767 | short | -32,768 to +32,767 |
| byte | -128 to +127 | ||
| TINYINT | -128 to +127 | byte | -128 to +127 |
| TIMSTAMPTIMESTAMP | YYYYMMDDHH | date | yyyyMMddHH |
Scroll pagebreak