Accomplish most common querying tasks using a set of queries available in the Visual editor: filter, aggregate, join, compute, union, and pattern.
Simple Query | CCL |
---|---|
Filter | WHERE clause |
Aggregate | GROUP BY clause |
Join | FROM clause, WHERE clause, ON clause |
Compute | Simple SELECT statement, with column expressions |
Union | UNION clause |
Pattern | MATCHING clause |
/**@SIMPLEQUERY=QUERY_TYPE*/where QUERY_TYPE is the shape name in the Visual editor.
For example, this comment causes a CREATE WINDOW statement to map to an Aggregate shape in the Visual editor: /**@SIMPLEQUERY=AGGREGATE*/ .