News for hackers. Stuff that matters.
Re:KSQL: Open Source Streaming SQL for Apache Kafka by nehanarkhede on Monday August 28, 2017 @07:35PM (#15121040)
Yes KSQL is ideal for use cases similar to those that CEP was initially targeted for and more - from real-time anomaly detection, monitoring, analytics to application development and Streaming ETL. As you alluded to, the big difference is that KSQL is designed as a distributed Streaming SQL engine that can run at Kafka scale.
Re:KSQL: Open Source Streaming SQL for Apache Kafka by edan0 on Tuesday August 29, 2017 @08:13PM (#15128712)
If you are interested in performing ultra low latency (<1ms) CEP via SQL, take a close look at SQLstream Blaze (http://www.sqlstream.com) and it's full implementation of Allen's Interval Algebra (https://en.wikipedia.org/wiki/Allen%27s_interval_algebra) via SQL temporal predicates: http://sqlstream.com/docs/sqlrf_planned_feature_temporal_pre.... This stuff runs at 1,000,000 events per second per core and can scale out in conjunction with Kafka across any number of servers.