SQL Queries

CedarDB has advanced SQL query capabilities. Using SQL, you can leverage CedarDBs advanced optimizer and execution engine to answer questions over large data fast. CedarDB automatically compiles your queries to efficient code and executes it in parallel to allow analyzing hundreds of gigabytes per second with ease.

• FROM / JOIN — FROM clause, all JOIN types, LATERAL
• GROUP BY — GROUP BY, HAVING, GROUPING SETS, ROLLUP, CUBE
• ORDER BY / LIMIT — ORDER BY, LIMIT, OFFSET, FETCH FIRST
• SELECT — SELECT clause, DISTINCT, DISTINCT ON, VALUES
• Set Operations — UNION, INTERSECT, EXCEPT
• Window functions — window functions, OVER clause
• WITH — CTEs, recursive CTEs