Hello All,
I’m still only getting into Calcite, but I couldn’t find anything regarding
pattern matching for streaming events (similar to what Esper offers). Could you
please help me understand how I could rewrite following query so Calcite is
able to parse and validate it:
SqlNode parse = planner.parse(“SELECT r1('ts') as ts FROM SqrtEdEvents
MATCH_RECOGNIZE (MEASURES A AS r1, B AS r2 PATTERN (A B) DEFINE A AS (A.sqrted
> THR), B AS (B.sqrted <= THR))”)
The EPL query compares ‘sqrted’ values from each two latest events and fires
immediately (and only once) when readings drop below ‘THR’ threshold.
Is there a plan within your community to enhance Calcite expressiveness in this
way or you don’t see a need for this? I would be happy to help.
Best Regards,
-Peter
--
Peter Michalák
CDT Cloud Computing for Big Data
Digital Institute, Newcastle University
www.bigdata-cdt.ac.uk<http://www.bigdata-cdt.ac.uk/>
linkedin.com/in/petermichalak<http://linkedin.com/in/petermichalak>
@petomichalak
