Simple Log Service:SQL Enhancement

Enable for a single query

1. Log on to the Simple Log Service console.

2. In the Projects section, click the one you want.

   

3. On the Log Storage > Logstores tab, click the logstore you want.

   

4. Click > SQL Enhancement.

Enable by default

1. Log on to the Simple Log Service console.

2. In the Projects section, click the one you want.

   

3. Click the icon.

   Click the Home icon in the top navigation bar to return to the Project list or switch Projects.

4. Hover over CUs of SQL-dedicated Instance and click Settings.

5. In the Modify CUs of SQL-dedicated Instance panel, turn on the Enable by Default switch, and then click OK.

Enable for a single query

• GetLogs (returns uncompressed results) - Query logs in a Logstore

  Configure one of the following parameters.

  • The powerSql parameter: set to true for SQL Enhancement, or false (default) for Standard SQL.

  • The query parameter: prepend set session parallel_sql=true; to your SQL statement. For example, * | select count(*) as pv becomes * | set session parallel_sql=true; select count(*) as pv.

• GetLogsV2 (returns compressed results) - Query log data in a Logstore

  Configure one of the following parameters.

  • The powerSql parameter: set to true for SQL Enhancement, or false (default) for Standard SQL.

  • The query parameter: prepend set session parallel_sql=true; to your SQL statement. For example, * | select count(*) as pv becomes * | set session parallel_sql=true; select count(*) as pv.

Enable by default

In the Create a Dedicated SQL instance operation, set useAsDefault=true to enable SQL Enhancement by default for the Project.

Prerequisites

Install the Java SDK

Enable for a single query

• GetLogs() method

  Configure one of the following parameters.

  • The powerSql parameter: set to true for SQL Enhancement, or false (default) for Standard SQL.

  • The query parameter: prepend set session parallel_sql=true; to your SQL statement. For example, * | select count(*) as pv becomes * | set session parallel_sql=true; select count(*) as pv.

  import com.aliyun.openservices.log.Client;
  import com.aliyun.openservices.log.exception.LogException;
  import com.aliyun.openservices.log.response.GetLogsResponse;
  import java.util.Date;
  public class CreateSqlInstance {
      public static void main(String[] args) throws LogException {
          // This example shows how to obtain an AccessKey ID and an AccessKey secret from environment variables.
          String accessId = System.getenv("ALIBABA_CLOUD_ACCESS_KEY_ID");
          String accessKey = System.getenv("ALIBABA_CLOUD_ACCESS_KEY_SECRET");
          // The endpoint for Simple Log Service. This example uses the endpoint for the China (Hangzhou) region. Replace it with the actual endpoint.
          String host = "https://cn-hangzhou.log.aliyuncs.com";
          // Create a Simple Log Service client.
          Client client = new Client(host, accessId, accessKey);
          // The Project name.
          String projectName = "aliyun-project-test";
          // The Logstore name.
          String logstore = "request_log";
          // Specifies whether to enable SQL Enhancement by default. Default value: false.
          boolean useAsDefault = true;
          // The SQL query statement.
          String query = "* | select count(1)";
          // The maximum number of logs to return. This parameter is valid only when the query parameter is a search statement. Value range: 0 to 100. Default value: 100.
          int line = 3;
          // The line number from which to start the query. This parameter is valid only when the query parameter is a search statement. Default value: 0.
          int offset = 0;
          // Specifies whether to return logs in reverse chronological order of log timestamps, accurate to the minute.
          // true: Returns logs in reverse chronological order.
          // false (default): Returns logs in chronological order.
          boolean reverse = false;
          // Specifies whether to use SQL Enhancement.
          // true: Use SQL Enhancement.
          // false (default): Use Standard SQL.
          boolean powerSql = true;
          int from = (int) (new Date().getTime() / 1000 - 600);
          int to = (int) (new Date().getTime() / 1000);
          GetLogsResponse getLogsResponse = client.GetLogs(projectName, logstore, from, to, "", query, line, offset, reverse, powerSql);
          System.out.println(getLogsResponse.getCpuSec());
      }
  }

Enable by default

Set boolean useAsDefault = true to enable SQL Enhancement by default for the Project.

import com.aliyun.openservices.log.Client;
import com.aliyun.openservices.log.exception.LogException;
import com.aliyun.openservices.log.request.CreateOrUpdateSqlInstanceRequest;
public class CreateSqlInstance {
    public static void main(String[] args) throws LogException {
        // This example shows how to obtain an AccessKey ID and an AccessKey secret from environment variables.
        String accessId = System.getenv("ALIBABA_CLOUD_ACCESS_KEY_ID");
        String accessKey = System.getenv("ALIBABA_CLOUD_ACCESS_KEY_SECRET");
        // The Project name.
        String projectName = "aliyun-test-project";
        // The endpoint for Simple Log Service. This example uses the endpoint for the China (Hangzhou) region. Replace it with the actual endpoint.
        String host = "https://cn-hangzhou.log.aliyuncs.com";
        // Create a Simple Log Service client.
        Client client = new Client(host, accessId, accessKey);
        int cu = 100;
        boolean useAsDefault = true;
        client.createSqlInstance(new CreateOrUpdateSqlInstanceRequest(projectName, cu, useAsDefault));
    }
}