ByteHouse provides two SQL modes, ClickHouse and ANSI.

For the ClickHouse mode, most of the SQL functions are the same as the community ClickHouse but also some self-developed functions are supported in ByteHouse. The following sections will use the content from 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:

Did this page help you?