tencent cloud

PrevNext

피드백

키워드를 검색하세요

Recent Pages

문서
Cloud Log Service
    문서
    Download PDF

    Lambda Function

    마지막 업데이트 시간:2024-01-22 10:52:48
    PDF 다운로드
      This document introduces the basic syntax and examples of Lambda functions.
      CLS allows you to define Lambda expressions in SQL analysis statements and pass them to specified functions to enrich the expressions of functions.

      Syntax

      Lambda expressions need to be used together with functions such as filter, reduce, transform, and zip_with. The syntax of a Lambda expression is as follows:
      parameter -> expression
      Parameter
      Description
      parameter
      Identifier used to pass the parameter.
      expression
      Expression. Most MySQL expressions can be used in Lambda expressions, such as:
      x -> x + 1 
(x, y) -> x + y 
x -> regexp_like(x, 'a+') 
x -> x[1] / x[2] 
x -> if(x > 0, x, -x) 
x -> coalesce(x, 0) 
x -> cast(x AS JSON) 
x -> x + try(1 / 0)

      Example

      Example 1. Using the Lambda expression "x-> x is not null"

      Return non-null elements in the [5, null, 7, null] array.
      Query and analysis statement
      * | SELECT filter(array[5, null, 7, null], x -> x is not null)
      Query and analysis result
      [5,7]

      Example 2. Using the Lambda expression "0, (s, x) -> s + x, s -> s"

      Return the sum of the elements in array [5, 20, 50].
      Query and analysis statement
      * | SELECT reduce(array[5, 20, 50], 0, (s, x) -> s + x, s -> s)
      Query and analysis result
      75

      Example 3. Using the Lambda expression "(k, v) -> v> 10"

      Map two arrays to a map with a key value greater than 10.
      Query and analysis statement
      * | SELECT map_filter(map(array['class01', 'class02', 'class03'], array[11, 10, 9]), (k,v) -> v > 10)
      Query and analysis result
      {"class01":11}

      Example 4. Using the Lambda expression "(x, y) -> (y, x)"

      Swap the positions of two elements in an array and extract the elements with the same index to form a new two-dimensional array.
      Query and analysis statement ```
      | SELECT zip_with(array['a', 'b', 'c'], array['d', 'e', 'f'], (x, y) -> concat(x, y)) ```
      Query and analysis result

      Example 5. Using the Lambda expression "x -> coalesce (x, 0) +1"

      Increment each element in the [5, NULL, 6] array by 1 and return. If the array contains a null element, the null element is converted to 0 and then incremented by 1.
      Query and analysis statement
      * | SELECT transform(array[5, NULL, 6], x -> coalesce(x, 0) + 1)
      Query and analysis result
      [6,1,7]

      Other examples

      * | SELECT filter(array[], x -> true)
      * | SELECT map_filter(map(array[],array[]), (k, v) -> true)
      * | SELECT reduce(array[5, 6, 10, 20], -- calculates arithmetic average: 10.25
                    cast(row(0.0, 0) AS row(sum double, count integer)),
                    (s, x) -> cast(row(x + s.sum, s.count + 1) AS row(sum double, count integer)),
                    s -> if(s.count = 0, null, s.sum / s.count))
      * | SELECT reduce(array[2147483647, 1], cast(0 AS bigint), (s, x) -> s + x, s -> s)
      * | SELECT reduce(array[5, 20, null, 50], 0, (s, x) -> s + x, s -> s)
      * | SELECT transform(array[array[1, null, 2], array[3, null]], a -> filter(a, x -> x is not null))
      
      문의하기

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

      문의하기
      기술 지원

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

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