1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
/* postgres can not */
/* syntax version 1 */
$list = AsList(3, 1, 2, 3);
$other_list = AsList(4);
$bool_list = AsList(true, false, true);
$struct_list = AsList(
AsStruct(1 AS one, 2 AS two),
AsStruct(-1 AS one, -2 AS two)
);
$script = @@
def formula(a, b, c, d):
return a * b + c // d
@@;
$udf = Python3::formula(
Callable<(Int64, Int64, Int64, Int64)->Int64>,
$script
);
$lambdaSum = ($x, $y) -> { RETURN $x + $y; };
$lambdaMult = ($x) -> { RETURN 4 * $x; };
$lambdaTuple = ($i, $s) -> { RETURN ($i * $s, $i + $s); };
$lambdaInc = ($i) -> { RETURN ($i + 1, $i + 2); };
SELECT
ListLength($list) AS length,
ListExtend($list, $other_list) AS extend,
ListZip($list, $other_list) AS zip,
ListZipAll($list, $other_list) AS zipall,
ListEnumerate($list) AS enumerate,
ListReverse($list) AS reverse,
ListSkip($list, 2) AS skip,
ListTake($list, 2) AS take,
ListSort($list) AS sort,
ListSort($struct_list, ($x) -> { return $x.two; }) AS sort_structs,
ListMap($list, ($item) -> { return $udf($item, 6, 4, 2); }) AS map,
ListFlatMap($list, ($item) -> { return $item / 0; }) AS flatmap,
ListFilter($list, ($item) -> { return $item < 3; }) AS filter,
ListAny($bool_list) AS any,
ListAll($bool_list) AS all,
ListMax($list) AS max,
ListMin($list) AS min,
ListSum($list) AS sum,
ListAvg($list) AS avg,
ListUniq($list) AS uniq,
ListConcat(ListMap($list, ($item) -> { return CAST($item AS String); })) AS concat,
ListExtract($struct_list, "two") AS extract,
ListMap($list, ($item) -> { return CAST($item AS Double);}),
ListCreate(Tuple<Int64,Double>),
ListCreate(TypeOf("foo")),
ListFold($list, 6, $lambdaSum),
ListFold([], 3, $lambdaSum),
ListFold(Just($list), 6, $lambdaSum),
ListFold(Just([]), 3, $lambdaSum),
ListFold(Null, 3, $lambdaSum),
ListFold1($list, $lambdaMult, $lambdaSum),
ListFold1([], $lambdaMult, $lambdaSum),
ListFold1(Just($list), $lambdaMult, $lambdaSum),
ListFold1(Just([]), $lambdaMult, $lambdaSum),
ListFold1(Null, $lambdaMult, $lambdaSum),
ListFoldMap($list, 1, $lambdaTuple),
ListFoldMap([], 1, $lambdaTuple),
ListFoldMap(Just($list), 1, $lambdaTuple),
ListFoldMap(Just([]), 1, $lambdaTuple),
ListFoldMap(Null, 1, $lambdaTuple),
ListFold1Map($list, $lambdaInc, $lambdaTuple),
ListFold1Map([], $lambdaInc, $lambdaTuple),
ListFold1Map(Just($list), $lambdaInc, $lambdaTuple),
ListFold1Map(Just([]), $lambdaInc, $lambdaTuple),
ListFold1Map(Null, $lambdaInc, $lambdaTuple);
|
