SQL Functions

ByteHouse provides two SQL dialects, (1) ClickHouse and (2) ANSI.

For the ClickHouse SQL, the SQL functions are mostly similar to what is provided in the community ClickHouse version, but it also includes additional functions that are only supported in ByteHouse. The following sections will use the content from ClickHouse.tech documentation site as the reference to describe how to use them in ByteHouse.

For the ANSI mode, ByteHouse provides a rich set of SQL syntax through ANSI SQL mode by using Apache Calcite. For the details please refer to the BNF-grammar here for more details: https://calcite.apache.org/docs/reference.html.