Topic

SQL pattern matching

Techniques for finding ordered patterns of rows in relational data, including row pattern recognition clauses and the window-function and gaps-and-islands workarounds that predate them.

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