Purpose of this document
This document defines the SQL structured query language used by SQLstream. The language is based on the SQL:2008 standard with some minor extensions to accommodate the concept of streams.
It contains information on
•Basic Building Blocks, including SQLstream Data Types, Streaming SQL Operators, and functions supported by streaming SQL, including built-in functions.
•Standard SQL operators: CREATE statements, DROP statements, SELECT statements, INSERT, MERGE, DELETE, ALTER statements
•Operators for transforming and filtering incoming data: WHERE, JOIN, GROUP BY, WINDOW. s-Server now features offset and hopping windows.
•Logical operators, including AS, AND, OR.
This document is aimed at Developers of SQLstream applications.
•SQLstream Concepts Guide
•Getting Started with SQLstream
•SQLstream Installation Guide
•SQLstream Administrator Guide
•SQLstream Glossary of Terms