Connecting to Impala
The Cloudera Impala™ connector allows users to visualize huge volumes of data stored in their Hadoop/HDFS cluster in real time and with no ETL.
Due to a JDBC driver limitation, the Impala connector does not support connecting over SSL in Zoomdata versions 2.2.0 through 2.2.6. Zoomdata released a fix for this in v2.2.7 service pack and you can find more information here.
The Zoomdata Server supports Impala v1.2.4 and later versions. Perform the following steps to configure the connector:
Specify the name of your source and add a description (if desired). Click
On the Connection page, define your connection source. You can select an existing connection, if available, or create a new one.
To create a new connection, select the Input new credentials option button, specify the connection name and enter a JDBC URL.
Specify JDBC URL in the following format: jdbc:hive2://SERVERNAME:PORT/;auth=noSasl
You can have more then one JDBC URL as long as they are separated by commas. The URLs will be utilized in a round-robin fashion. These fields are required.
Click Validate . After successful validation, the values will be saved. Click Next .
On the Tables page, select the schema and the data collection to use for your charts. The selected fields will be displayed in the Preview section. If you don't want to use specific fields, clear the checkboxes in the Fields section.
If you want to add a custom SQL query to retrieve the data, click Custom SQL and add your query.
Click Next .
By default SparkIt is disabled. You can enable it if required. Click Next .
On the Fields page, you can create unique label names for the available fields in your data source. These labels will be displayed in the charts.
If necessary, change the Type , Partition , and Default options and select the Distinct Count checkbox to enable this option . For the Filter Display column, you may configure a Custom Range, if available. Click Next .
- On the Refresh page, you can schedule asynchronous jobs to refresh fields in your data source. Refer to Using the Zoomdata Scheduler article for more information.
On the Charts page, you can enable the charts that will be available for the data source and edit the settings for your charts. That is, select the styles that will be available for the data source, change the global default settings, and more. Learn more about how to customize a chart .
- Click Finish to save your changes.