yql/essentials/tests/sql/suites/aggregate/fail_on_match_recognize_specific.sqlx


1
2
3
4
5
6
7
8
9
10
11
12
13
14

$input = SELECT * FROM AS_TABLE([
    <|time: 0,   value: 1u, name: "A"|>,
    <|time: 100, value: 2u, name: "A"|>,
    <|time: 200, value: 3u, name: "B"|>,
    <|time: 300, value: 3u, name: "B"|>,
    <|time: 400, value: 4u, name: "A"|>,
    <|time: 500, value: 5u, name: "A"|>,
]);

SELECT
    FIRST(value) as first,
    LAST(value) as last
FROM $input
GROUP BY name;