tencent cloud

PrevNext

피드백

키워드를 검색하세요

Recent Pages

문서
Cloud Log Service
    문서
    Download PDF

    General Aggregate Function

    마지막 업데이트 시간:2024-03-20 11:47:49
    PDF 다운로드
    This document describes the basic syntax and examples of aggregate functions.
    An aggregate function calculates a set of values and returns the calculation result. CLS supports the following aggregate functions.
    Note:
    In CLS analysis statements, strings must be included in single quotes (''), and field names and column names are unsigned or included in double quotes (""). For example, 'status' indicates the string 'status', and status or "status" indicates the log field status.
    Function
    Description
    Example
    arbitrary(KEY)
    Returns an arbitrary non-null value of the KEY column.
    * | SELECT arbitrary(request_method) AS request_method
    avg(KEY)
    Returns the average (arithmetic mean) of the KEY column.
    * | SELECT AVG(request_time)
    bitwise_and_agg(KEY)
    Returns the bitwise AND result of all input values of the KEY column.
    * | SELECT bitwise_and_agg(status)
    bitwise_or_agg(KEY)
    Returns the bitwise OR result of all input values of the KEY column.
    * | SELECT bitwise_or_agg(request_length)
    checksum(KEY)
    Returns the checksum of the KEY column. The return result is of Base64 encoding type.
    * | SELECT checksum(request_method) AS request_method
    count(*)
    Returns the number of input rows.
    * | SELECT COUNT(*) WHERE http_status >200
    count(1)
    Returns the number of input rows. This function is equivalent to count(*).
    * | SELECT COUNT(1)
    count(KEY)
    Returns the number of non-null input values of the KEY column.
    * | SELECT COUNT(request_time) WHERE request_time >5.0
    count_if(boolean)
    Returns the number of logs that meet specified conditions.
    * | select count_if(returnCode>=400) as errorCounts
    geometric_mean(KEY)
    Returns the geometric mean of KEY, which cannot contain negative numbers; otherwise, the result will be NaN.
    * | SELECT geometric_mean(request_time) AS request_time
    max(KEY)
    Returns the maximum value of KEY.
    * | SELECT MAX(request_time) AS max_request_time
    max_by(x,y)
    Returns the value of x associated with the maximum value of y over all input values.
    * | SELECT MAX_BY(request_method, request_time) AS method
    max_by(x,y,n)
    Returns n values of x associated with the n largest of all input values of y in descending order of y.
    * | SELECT max_by(request_method, request_time, 3) AS method
    min(KEY)
    Returns the minimum value of KEY.
    * | SELECT MIN(request_time) AS min_request_time
    min_by(x,y)
    Returns the value of x associated with the minimum value of y over all input values.
    * | SELECT min_by(request_method, request_time) AS method
    min_by(x,y,n)
    Returns n values of x associated with the n smallest of all input values of y in descending order of y.
    * | SELECT min_by(request_method, request_time, 3) AS method
    sum(KEY)
    Returns the sum of the KEY column.
    * | SELECT SUM(body_bytes_sent) AS sum_bytes
    bool_and(boolean)
    Returns TRUE if all logs meet the specified condition or FALSE otherwise.
    * | select bool_and(returnCode>=400)
    bool_or(boolean)
    Returns TRUE if any log meets the specified condition or FALSE otherwise.
    * | select bool_or(returnCode>=400)
    every(boolean)
    Equivalent to bool_and(boolean).
    * | select every(returnCode>=400)

    Field description

    Parameter
    Description
    KEY
    Name of the log field.
    x
    The parameter value can be of any data type.
    y
    The parameter value can be of any data type.
    n
    An integer greater than 0.
    
    문의하기

    고객의 업무에 전용 서비스를 제공해드립니다.

    문의하기
    기술 지원

    더 많은 도움이 필요하시면, 티켓을 통해 연락 바랍니다. 티켓 서비스는 연중무휴 24시간 제공됩니다.

    티켓 제출
    연중무휴 24시간 전화 지원
    Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
    개인정보 처리방침서비스 약관쿠키 정책