Language

Core Query Grammar

The basic single-query shape is:

Guide

The basic single-query shape is:

text
SELECT <projection-list>
INTO <output-name>
FROM <input-name> [TIMESTAMP BY <field-path>]
[WHERE <condition>]
[GROUP BY <group-key-list>, TumblingWindow(Duration(<unit>, <value>)[, Offset(<unit>, <value>)])]
[HAVING <aggregate-condition>]

The simplest tested forms are:

sql
SELECT value INTO output FROM input
SELECT input.field1.field2.field3.field4.field5 INTO output FROM input
SELECT * INTO output FROM input
SELECT value INTO output FROM input TIMESTAMP BY ts

ChronusQL requires `INTO`. The tests reject:

sql
SELECT value FROM input

Only one physical input is supported per standard SQL statement:

sql
SELECT value INTO output FROM input, other

This is rejected with an error indicating one input is supported.

PreviousInput and Output ModelNextProjection and Aliases