ApsaraDB for ClickHouse supports the following SQL features in addition to the standard syntax and functions.
| Feature | Description | Reference |
|---|---|---|
| Operators | SQL operators and their precedence, including arithmetic, comparison, logical, and string operators — each mapped to an equivalent ClickHouse function | Operators |
| Conditional operators | The EXISTS operator, which returns 1 if a subquery produces any rows and 0 if the subquery is empty | EXISTS |
| IN operators | The IN, NOT IN, GLOBAL IN, and GLOBAL NOT IN operators, including how distributed subqueries behave differently with IN versus GLOBAL IN | IN Operators |
| Distributed DDL statements | The ON CLUSTER clause for running DDL queries (such as CREATE TABLE and ALTER TABLE) across all nodes in a cluster | Distributed DDL Queries (ON CLUSTER Clause) |