Querying data in Arroyo SQL
FROM
clause specifies the primary source of data.
It will be either a table name or subquery.
The table name can be either a saved source,
a table created in the WITH
clause or a table created via CREATE TABLE
and inserted into.
Tables can be given aliases, but will default to their name as the alias for things like joins.
JOIN
clause allows you to join multiple tables together.
See the join documentation for more details.
WHERE
clause allows you to filter the data with a boolean condition.
This predicate is applied to the incoming rows, so cannot include conditions on the resulting columns.
GROUP BY
clause is used to compute aggregates over some set of fields.
All GROUP BY queries will implicitly include a time window,
and if the input doesn’t already have a time window,
it should be specified as one of the grouping fields.
For example,
UNNEST
operator allows you to unnest arrays into multiple rows. This can be used
as a normal scalar function with the following restrictions:
SELECT
clause