0.35.10 (2024-04-09)

Bug Fixes

• cubesql: has_schema_privilege - compatiblity with PostgreSQL (#8098) (42586cf)

0.35.9 (2024-04-08)

Features

• cubestore: Upgrade rust to 1.77.0-nightly (635124704 2024-01-27) (#7640) (5aa5abb)
• docker: Security upgrade Node.js from 18.19.1 to 18.20.1 (#8094) (51921cc)

0.35.8 (2024-04-05)

Bug Fixes

• schema-compiler: quote case sensitive idents (#8063) (6273532)

Features

• cubestore: Queue - optimize list/pending operations (#7998) (815be2f)

0.35.7 (2024-04-03)

Features

• cross: Upgrade LLVM from 14 to 18 (02042024) (#8064) (9b30eac)
• cubestore: Upgrade LLVM from 14 to 18 (#8068) (d1f0cbc)

0.35.6 (2024-04-02)

Bug Fixes

• cubesql: Remove binary expression associative rewrites (19f6245)
• cubestore: RocksStore - migrate table by truncate (unknown tables) (#8053) (509d895)

Features

• cubestore: CacheStore - allow to disable logs (#8027) (ce6303c)
• Ungrouped query pre-aggregation support (#8058) (2ca99de)

0.35.5 (2024-03-28)

Bug Fixes

• cubesql: SQL push down of ORDER BY causes Invalid query format: "order[0][0]" with value fails to match the required pattern: /^[a-zA-Z0-9_]+.[a-zA-Z0-9_]+$/ (#8032) (0681725)
• cubestore: RocksStore - improve panic safety on migration (#8031) (f81e2cb)
• Multiplied count measure can be used as additive measure in pre-… (#8033) (f36959c)
• schema-compiler: Upgrade babel/traverse to 7.24 (GHSA-67hx-6x53-jw92) (#8002) (9848e51)

0.35.4 (2024-03-27)

Bug Fixes

• cubesql: Flatten aliasing breaks wrapped select ORDER BY expressions (#8004) (eea88ec)
• query-orchestrator: Missing dataSource in pre-aggregation preview query (#7989) (d3012c8)

Features

• cubesql: Support DISTINCT push down (fc79188)

0.35.3 (2024-03-22)

Bug Fixes

• Render all distinct counts as 1 for ungrouped queries to not fail ratio measures (#7987) (f756e4b)

0.35.2 (2024-03-22)

Bug Fixes

• cubesql: Fix timestamp parsing format string (938b13c)
• mssql-driver: Unsupported option opt.evictionRunIntervalMillis, refs #7951 (#7977) (53f013a)

Features

• cubesql: Flatten rules to allow multiple level transformation queries be executed by split and SQL push down (#7979) (f078adc)
• cubesql: Parse timestamp strings as Date32 (4ba5a80)
• cubesql: Support a ^ b exponentiation (914b058)
• cubestore: Queue - reduce memory usage (#7975) (e9848e8)
• cubestore: Reduce memory usage while writting WALs (#7967) (ee9fa71)
• query-orchestrator: Queue - improve performance (#7983) (56d48fb)

Reverts

• Revert "feat(schema-compiler): composite key generation (#7929)" (61e4c45), closes #7929

0.35.1 (2024-03-18)

Bug Fixes

• cubestore: Wrong calculation of default compaction trigger size (too often compaction) (#7960) (2f4b75b)

Features

• docker: Security upgrade node from 18.19.0 to 18.19.1 (#7924) (f33d03e)
• duckdb-driver: Upgrade DuckDB to v0.10 (#7920) (0e9103a)
• mssql-driver: Upgrade mssql to 10.0.2 (Node.js 17+ compatiblity), fix #7951 (7adaea6)
• schema-compiler: composite key generation (#7929) (5a27200)

0.35.0 (2024-03-14)

Breaking changes

• Remove alpine docker images
• Rename cubejsApi to cubeApi in client packages
• Change default value for CUBEJS_SCHEMA_PATH to model
• Remove MySQL protocol support for SQL API
• Remove serverless packages
• Support for Node.js 14 was removed
• Remove support for initAppt
• Enable CUBEJS_DB_FETCH_COLUMNS_BY_ORDINAL_POSITION by default

Bug Fixes

• cubesql: Don't ignore second filter over same time dimension (03e7f3a)
• cubestore-driver: Compatibility with Node.js 18 (localhost resolved to ipv6) (f7a4fab)

Features

• docker: Upgrade Node.js to 18.x (8b5b923)

0.34.62 (2024-03-13)

Bug Fixes

• cubesql: Fix push down column remapping (8221a53)
• Job API - correct handling on missed pre_aggregation (#7907) (6fcaff4)
• Job API - correct handling when job is not_found (#7894) (cae1866)
• query-orchestrator: Job API - builds are not triggered, fix #7726 (#7909) (738dbde)

0.34.61 (2024-03-11)

Bug Fixes

• cubesql: Error out when temporary table already exists (1a0a324)
• cubesql: Fix push down CASE with expr (f1d1242)
• cubesql: Fix push down column remapping (c7736cc)
• cubesql: Partition pruning doesn't work when view uses proxy member (#7866) (c02a07f), closes #6623
• cubesql: Trim ".0" postfix when converting Float to Utf8` (3131f94)
• Wrong sql generation when multiple primary keys used (#6689) Thanks @alexanderlz ! (2540a22)

Features

• clickhouse-driver: Support export bucket for S3 (write only) (#7849) (db7e2c1)
• clickhouse-driver: Support S3 export for readOnly mode (7889aad)
• cubesql: Support FETCH ... n ROWS ONLY (53b0c14)
• query-orchestrator: Support unload (export bucket) for readOnly drivers (76ce7ed)

Reverts

• Revert "fix(cubesql): Fix push down column remapping" (#7895) (dec8901), closes #7895

0.34.60 (2024-03-02)

Bug Fixes

• Bump max connect retries for Cube Store (00a6ec0)
• client-core: incorrect index in movePivotItem (#6684) Thanks to @telunc! (82217b2)
• cubesql: Allow different Timestamp types in DATEDIFF (de9ef08)
• cubesql: Incorrect CASE WHEN generated during ungrouped filtered count (#7859) (f970937), closes #7858
• cubesql: Prioritize ungrouped aggregate scans over ungrouped projection scans so most of the members can be pushed down without wrapping (#7865) (addde0d)
• cubesql: Remove excessive limit on inner wrapped queries (#7864) (b97268f)

Features

• cubesql: In subquery support (#7851) (8e2a3ec)
• cubesql: Support split and SUM(1) (16e2ee0)

0.34.59 (2024-02-28)

Bug Fixes

• cubesql: Replace only simple ungrouped measures in projections to avoid aggregate over aggregate statements (#7852) (fa2a89b)
• Ungrouped filtered count should contain CASE WHEN statement bu… (#7853) (8c37a40)

0.34.58 (2024-02-27)

Bug Fixes

• clickhouse-driver: Correct support for Enum8/16 (#7814) (db37fc3)
• cubesql: Ambiguous reference in case of same two 16 char prefixes are in query (5051f66)
• cubesql: Continue wait error is being thrown to users (cb2376c)

Features

• materialize-driver: Add cluster option to Materialize driver (#7773) Thanks @bobbyiliev! (917004e)

0.34.57 (2024-02-26)

Bug Fixes

• cubesql: ungrouped query can be routed to Cube Store (#7810) (b122837)
• cubesql: Can't find rewrite due to AST node limit reached for remaining non-equivalent date and timestamp constant folding rules (b79f697)
• cubesql: More readable error message during SQL generation (d9a7194)
• cubesql: Support Z postfix in Timestamp response transformation (c013c91)
• cubesql: Timestamp equals filter support (754a0df)
• cubesql: writerOrChannel.resolve is not a function (abc95e2)

Features

• cubesql: WHERE SQL push down (#7808) (98b5709)
• cubesql: Allow replacement of aggregation functions in SQL push down (#7811) (97fa757)
• cubesql: Support placeholders in OFFSET, FETCH ... (60aad90)
• cubesql: Support temporary tables (7022611)
• duckdb-driver: Add support for local fs duckdb database path (#7799) (77cc883)

0.34.56 (2024-02-20)

Bug Fixes

• cubesql: Allow NULL values in CASE (a97acdc)
• cubesql: Streaming still applies default limit (a96831d)
• Gracefully handle logical expressions in FILTER_PARAMS and introduce FILTER_GROUP to allow use FILTER_PARAMS for logical expressions (#7766) (736070d)

0.34.55 (2024-02-15)

Bug Fixes

• Cannot read properties of null (reading 'includes') (9b50382)
• cubesql: Quote FROM alias for SQL push down to avoid name clas… (#7755) (4e2732a)

Features

• cubesql: Strings with Unicode Escapes (#7756) (49acad5)

0.34.54 (2024-02-13)

Bug Fixes

• cubesql: Cannot read properties of undefined (reading 'preAggregation') with enabled SQL push down (ac2cc17)