Adjusting the Execution of Adaptive Queries in HetuEngine

Scenario

Typically, SQL statements of large tasks (for example, scanning large amounts of data from an entire table) occupy a large number of resources, which affects the load of other tasks in case that resources are insufficient. This deteriorates user experience and increases O&M costs. To resolve this issue, HetuEngine provides the adaptive query execution function to allow adaptive scheduling and execution of queries.

This section describes how to enable adaptive query execution.

Procedure

1. Log in to FusionInsight Manager as a HetuEngine administrator and choose Cluster > Services > HetuEngine.
2. On the Dashboard tab page that is displayed, find the Basic Information area, and click the link next to HSConsole WebUI.
3. On the page that is displayed, click Data Source, locate the row containing the Hive data source to be modified, and click Edit in the Operation column.
4. Add hive.strict-mode-restrictions to the custom parameters and set it to NONE to enable the adaptive query execution function. For details, see 6.g.
5. Click OK.
6. Restart the HetuEngine service.

   Log in to the Manager. On the Dashboard page, click More and select Restart Service to restart the HetuEngine service as prompted.

7. Restart the HetuEngine compute instance that is running.

   On HSConsole, click Compute Instances, select the running HetuEngine instance, click Restart, and operate as prompted.