(v22) Enable Data Sharpening for Cloudera Impala Data Sources

Enable Data Sharpening for Cloudera Impala Data Sources

Data Sharpening works with certain partitioned Impala data sources. The partitioned field should be a time-based attribute and in a supported time format (for example, yyyy-MM-dd). Follow the steps below to set up Data Sharpening for an Impala data source.

To configure Data Sharpening for a Cloudera Impala data source configuration:

1. Log into Composer (either as an administrator or as a user who has been assigned to a group with data source management privileges).

2. Select Sources on the UI menu () or the top-level navigation menu, or select the Sources box on the Home page. The Sources page appears.

3. Select the appropriate data source configuration to edit it, then access the Fields tab of the data source.

4. Locate and select the time field you want to use as the driving time field. Select an appropriate time granularity in the Data Details section of the Settings side bar menu, then Save your changes. Consider the 10% rule to ensure Data Sharpening runs when you want it to. See When Data Sharpening Occurs for more information.

5. Select the Global Settings tab, and enable Time Bar if not enabled to access the data sharpening settings. See Configure Time Bar Defaults.

6. Select the time field you want to use as the driving time field in the drop down for Default Time Attribute.

7. Enable the Prefer Sharpening toggle to enable sharpening and sharpening settings.

8. Optionally, use the Max Queries slider to specify the maximum number of queries used for Data Sharpening. The default maximum is 10 queries.

9. When your changes are complete, select Save Settings to save your changes.