Simple Log Service:SQL Enhancement

Enabled once

1. Log on to the Simple Log Service console.

2. In the Projects section, click the project that you want to manage.

   

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

   

4. Choose > SQL Enhancement.

   

Enabled by default

1. Log on to the Simple Log Service console.

2. In the Projects section, click the project that you want to manage.

   

3. Click the icon.

   

4. Move your pointer over CUs of SQL-dedicated Instance, and then click Modify.

   

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

Enabled once

• GetLogs (the query results are not compressed and are directly returned)

  You need to only configure one of the following parameters:

  • powerSql: Valid values: true and false (default). The value true specifies that the current query uses SQL Enhancement. The value false specifies that the current query uses Standard SQL.

  • query: In this example, the * | select count(*) as pv query statement is executed. Add set session parallel_sql=true; to the analytic statement, indicating that SQL Enhancement is used. The query statement becomes * | set session parallel_sql=true; select count(*) as pv.

• GetLogsV2 (the query results are compressed and then returned)

  You need to only configure one of the following parameters:

  • powerSql: Valid values: true and false (default). The value true specifies that the current query uses SQL Enhancement. The value false specifies that the current query uses Standard SQL.

  • query: In this example, the * | select count(*) as pv query statement is executed. Add set session parallel_sql=true; to the analytic statement, indicating that SQL Enhancement is used. The query statement becomes * | set session parallel_sql=true; select count(*) as pv.

Enabled by default

CreateSqlInstance: In this operation, set useAsDefault to true to automatically enable SQL Enhancement for your project.

Prerequisites

Simple Log Service SDK for Java is installed. For more information, see Install Simple Log Service SDK for Java.

Enabled once

• GetLogs() method

  You need to only configure one of the following parameters:

  • powerSql: Valid values: true and false (default). The value true specifies that the current query uses SQL Enhancement. The value false specifies that the current query uses Standard SQL.

  • query: In this example, the * | select count(*) as pv query statement is executed. Add set session parallel_sql=true; to the analytic statement, indicating that SQL Enhancement is used. The query statement 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 {
          // Configure environment variables. In this example, the AccessKey ID and AccessKey secret are obtained from environment variables.
          String accessId = System.getenv("ALIBABA_CLOUD_ACCESS_KEY_ID");
          String accessKey = System.getenv("ALIBABA_CLOUD_ACCESS_KEY_SECRET");
          // The Simple Log Service endpoint. In this example, the Simple Log Service endpoint for the China (Hangzhou) region is used. Replace the parameter value with the actual endpoint.
          String host = "https://cn-beijing.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";
          // Specify Whether to use SQL Enhancement. Default value: false.
          boolean useAsDefault = true;
          // Specify the query statement.
          String query = "* | select count(1)";
          // The maximum number of logs to return for the request. This parameter takes effect only when the query parameter is set to a search statement. Minimum value: 0. Maximum value: 100. Default value: 100.
          int line = 3;
          // The line from which the query starts. This parameter takes effect only when the query parameter is set to a search statement. Default value: 0.
          int offset = 0;
          // Specify whether to return logs in reverse chronological order of log timestamps. The log timestamps are accurate to the minute. Valid values:
          // true: Logs are returned in reverse chronological order of log timestamps.
          // false (default): Logs are returned in chronological order of log timestamps.
          boolean reverse = false;
          // Specify whether to use SQL Enhancement. Valid values:
          // true: uses SQL Enhancement.
          // false (default): uses 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, "", sql, line, offset, reverse, powerSql);
          System.out.println(getLogsResponse.getCpuSec());
      }
  }

Enabled by default

Set boolean useAsDefault to true to automatically enable SQL Enhancement for your 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 {
        // Configure environment variables. In this example, the AccessKey ID and AccessKey secret are obtained 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 Simple Log Service endpoint. In this example, the Simple Log Service endpoint for the China (Hangzhou) region is used. Replace the parameter value with the actual endpoint.
        String host = "https://cn-beijing.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));
    }
}