standard

MATCH_RECOGNIZE

SQL clause for row pattern recognition: it partitions and orders rows, defines named row conditions in a DEFINE block, and matches sequences against a regular-expression-style pattern.

Known aliases

MATCH_RECOGNIZE clause
row pattern recognition

Relationships

No evidence-backed relationships are recorded.

Current clusters

build1 publisher

Databricks puts MATCH_RECOGNIZE in its compute with the failure window anchored inside DEFINE

Databricks says the clause is now available in its compute, including Lakehouse Real-Time. In the DEFINE block, FIRST(FAIL.event_time) pins an hour-long window to the first failure of each match.

Publishers:databricks.com

Reality

Evidence52
Adoption18
Hype gap+22
Incentives88
Confidence46