Streaming SQL Reference Guide

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Streaming SQL Reference Guide

Previous pageReturn to chapter overviewNext page

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.

Audience

This document is aimed at Developers of SQLstream applications.

Related Documents

SQLstream Concepts Guide

Getting Started with SQLstream

SQLstream Installation Guide

SQLstream Administrator Guide

SQLstream Glossary of Terms