Help Center/ MapReduce Service/ Component Operation Guide (LTS) (Ankara Region)/ Using HetuEngine/ HetuEngine Performance Tuning/ Adjusting the Execution of Adaptive Queries
Updated on 2024-11-29 GMT+08:00
View PDF
Share

Adjusting the Execution of Adaptive Queries

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.