@cubejs-backend/query-orchestrator - npm Package Versions

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.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.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)

0.34.52 (2024-02-13)

Bug Fixes

• cubesql: Support new Metabase meta queries (0bc09fd)
• cubestore: Error in queries with GROUP BY DIMENSION (#7743) (b9fcc60)
• cubestore: Use file_name instead of id for in memory chunks (#7704) (9e2e925)

Features

• cubesql: Always Prefer SQL push down over aggregation in Datafusion (#7751) (b4b0f05)
• cubesql: EXTRACT(EPOCH, ...) support (#7734) (b4deacd)
• cubesql: Support TimestampNanosecond in CASE (69aed08)
• cubesql: Support Athena OFFSET and LIMIT push down (00c2a6b)
• duckdb-driver: pass Cube user agent (6b7aff6)

0.34.51 (2024-02-11)

Bug Fixes

• cubesql: Enable constant folding for unary minus exprs (704d05a)
• cubesql: Fix CASE type with NULL values (2b7cc30)
• cubesql: Stabilize split operations for SQL push down (#7725) (6241e5e)
• native: Don't crash after query cancellation (40726ba)
• native: Handle JsAsyncChannel error (without panic) (#7729) (5480978)
• playground: replace antd daterange picker (#7735) (484f1ca)

Features

• Add ungrouped flag to GraphQL API (#7746) (6111fbb)
• cubesql: Extend DATEDIFF push down support (ecaaf1c)
• cubestore: CREATE TABLE IF NOT EXISTS support (#7451) (79c5e92)

0.34.50 (2024-01-31)

Bug Fixes

• cubestore: Single job process don't stop after job done (#7706) (b84a345)
• Merge streaming methods to one interface to allow SQL API use batching and Databricks batching implementation (#7695) (73ad72d)
• playground: replace antd popover for settings (#7699) (56b44ee)

0.34.48 (2024-01-25)

Bug Fixes

• cubesql: Fix unary minus operator precedence (d5a935a)
• cubesql: Segment mixed with a filter and a date range filter may affect push down of inDateRange filter to time dimension (#7684) (f29a7be)
• cubesql: Support Sigma Sunday week granularity (3d492eb)
• Join order is incorrect for snowflake schema views with defined join paths (#7689) (454d456), closes #7663

Features

• cubesql: Support KPI chart in Thoughtspot (dbab39e)
• cubesql: Support unwrapping BINARY expr from SUM(<expr>) (#7683) (ce93cc7)
• View members inherit title, format and drillMembers attribute (#7617) Thanks @CallumWalterWhite ! (302a756)