SQL Syntax

SynxDB Cloud is built on Apache Cloudberry™ (Incubating) as its database engine. Therefore, its SQL syntax, system functions, and data types are highly compatible with Apache Cloudberry™ (Incubating). Users can refer to the Apache Cloudberry™ (Incubating) SQL statement reference for detailed syntax and usage.

However, SynxDB Cloud introduces several architectural and functional changes compared to Apache Cloudberry™ (Incubating). As a result, while the SQL syntax remains highly compatible, actual behaviors might differ. Users should always refer to SynxDB Cloud documentation and validate their queries based on the product’s actual execution behaviors. Some key differences include:

  • Index management: SynxDB Cloud does not support the CREATE INDEX statement, and index-related DDL statements are unavailable.

  • Resource management: SynxDB Cloud uses a container-based resource management system, which differs from Apache Cloudberry™ (Incubating)’s resource queue mechanism.

  • Separation of storage and compute: Certain DDL, DML, and query optimization strategies have been adjusted to align with the storage-compute separation architecture, leading to behavioral differences from Apache Cloudberry™ (Incubating).