Skip to content

Pattern to match with the start of a partition  #272

@dakotahNorth

Description

@dakotahNorth

There is no way with match_recognize in Esper to stay match with the start of the partition.

Would be fantastic to have the ability, like the ^ in snowflake, to match with the start of the partition.

The following pattern matches a stock with a price greater than 75.00 at the beginning of the partition:

pattern (^ gt75)
define
    gt75 as price > 75.00

In PATTERN (^ GT75), the first row (not the second row) must have a price greater than 75.00.

Example from
https://docs.snowflake.com/en/user-guide/match-recognize-introduction.html#label-match-recognize-introduction-search-start-or-end-partition

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions