Enabling Dynamic Filtering in HetuEngine

HetuEngine provides the dynamic filtering function, which significantly improves the performance in join scenarios.

This section describes how to enable dynamic filtering.

1. Log in to FusionInsight Manager as a user who can access the HetuEngine web UI and choose Cluster > Services > HetuEngine. The HetuEngine service page is displayed.
2. In the Basic Information area on the Dashboard tab page, click the link next to HSConsole WebUI. The HSConsole page is displayed.
3. In the Compute Instance page, locate the row that contains the tenant to which the target instance belongs and click Configure in the Operation column.
4. In the Custom Configuration area, click Add to add the following parameters:

   Table 1 Dynamic filtering parameters

   Parameter	Value	ConFile	Parameter Description
   enable-dynamic-filtering	true	coordinator.config.properties and worker.config.properties	Whether to enable the dynamic filtering function. The default value is false.

5. Set Start Now to Yes and click OK.