SQL Syntax Guide

The SQL Syntax Guide provides a collection of SQL syntaxes that is supported in SQL Stream Builder.

SQL Syntax

• Filtering WHERE
• Projections FOO || 'baz'
• Tumble, Hopping window expressions TUMBLE(), HOP()
• Grouping GROUP BY
• Filter after aggregation HAVING
• Join JOIN ON..
• Comparison operators
• Logical operators
• Arithmetic operators and functions
• Character string operators and functions
• Binary string operators and functions
• Date/Time functions
• Type conversion
• Aggregate functions
• Grouped window functions
• Grouped Auxiliary functions

Data types

• Datatypes

Metadata commands

• show tables - list virtual tables.
• desc <vtable> - describe the specified virtual table, showing columns and types.
• show jobs - list current running SQL jobs.
• show history - show SQL query history (only successfully parsed/executed).
• help - show help.