Streaming - SQL

About

continuous SQL query on an infinite data stream

A streaming sql can not be ANSI SQL compliant because the streaming functions are not part of those database standards.

A streaming query is a query that executes continuously over streaming data.

In real-time, streaming queries:

• operates continuously on data
• updates results incrementally
• outputs a result if the condition is met

Articles Related

Usage

• real-time alerts
• sensor data analytics (weather, temperatur..).

Windows

Stream - Windows

Syntax

MATCH_RECOGNIZE clause

• originated in Oracle Continuous Query Language (Oracle CQL), based on SQL and used on streaming data.
• See also esper match-recognize

Language

• Ksql vs flink sql
• Fusion Middleware Oracle CQL Language Reference for Oracle Event Processing
• Beam SQL DSL. Apache Beam Proposal: Add SQL to Beam Authors: [email protected] JIRA issue: BEAM-301

Implementation

• uber/AthenaX
• http://sqlstream.com/ - SQL on Kafka already

Documentation / Reference

• https://thenewstack.io/confluent-brings-sql-querying-kafka-streaming-data/
• https://sqlstream.com/why-sql/