v0.35.1

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)

v0.35.0

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)

v0.34.62

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

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

v0.34.60

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)

v0.34.59

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)

v0.34.58

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)

v0.34.57

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)

v0.34.56

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)

v0.34.55

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)