WITH子句

语法

WITH table_name AS (select_statement) select_statement

参数说明

示例

在名为website_log的Logstore中分析每台主机对应的平均请求长度，并将分析结果保存到表T1中；在名为access_log的Logstore中分析每台主机对应的平均请求长度，并将分析结果保存到表T2中。然后联合查询表T1和表T2，获取两个表中相同主机对应的平均请求长度。

• 查询和分析语句

  * | with T1 AS (
    SELECT
      host,
      avg(request_length) length
    FROM    website_log
    GROUP BY
      host
  ),
  T2 AS (
    SELECT
      host,
      avg(request_length) length
    FROM    access_log
    GROUP BY
      host
  )
  SELECT
    T1.host,
    T1.length,
    T2.length
  FROM  T1
    JOIN T2 ON T1.host = T2.host

• 查询和分析结果