Struct MatchRecognize 

pub struct MatchRecognize {
    pub this: Option<Box<Expression>>,
    pub partition_by: Option<Vec<Expression>>,
    pub order_by: Option<Vec<Ordered>>,
    pub measures: Option<Vec<MatchRecognizeMeasure>>,
    pub rows: Option<MatchRecognizeRows>,
    pub after: Option<MatchRecognizeAfter>,
    pub pattern: Option<String>,
    pub define: Option<Vec<(Identifier, Expression)>>,
    pub alias: Option<Identifier>,
    pub alias_explicit_as: bool,
}

MATCH_RECOGNIZE clause for row pattern matching (Oracle/Snowflake/Presto/Trino)

Fields

this: Option<Box<Expression>>

Source table/expression

partition_by: Option<Vec<Expression>>

PARTITION BY expressions

order_by: Option<Vec<Ordered>>

ORDER BY expressions

measures: Option<Vec<MatchRecognizeMeasure>>

MEASURES definitions

rows: Option<MatchRecognizeRows>

Row semantics (ONE ROW PER MATCH, ALL ROWS PER MATCH, etc.)

after: Option<MatchRecognizeAfter>

AFTER MATCH SKIP behavior

pattern: Option<String>

PATTERN definition (stored as raw string for complex regex patterns)

define: Option<Vec<(Identifier, Expression)>>

DEFINE clauses (pattern variable definitions)

alias: Option<Identifier>

Optional alias for the result

alias_explicit_as: bool

Whether AS keyword was explicitly present before alias

Trait Implementations

impl Clone for MatchRecognize

fn clone(&self) -> MatchRecognize

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for MatchRecognize

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for MatchRecognize

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for MatchRecognize

fn eq(&self, other: &MatchRecognize) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Serialize for MatchRecognize

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for MatchRecognize