Functions

ByConity 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 ByConity. The following sections will use the content from ClickHouse.tech documentation site as the reference to describe how to use them in ByConity.

For the ANSI mode, ByConity 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.