0.31.18 (2022-11-28)

Bug Fixes

• cubesql: Prevent infinite limit push down (f26d40a)
• cubesql: Push down projection to CubeScan with literals (207616d)

Features

• cubesql: Sigma Computing date filters (404e3f4)
• yaml schema generation (#5676) (fc0b810)

0.31.17 (2022-11-23)

Features

• cubestore: Introduce CacheStore (#5607) (36dee61)

0.31.16 (2022-11-23)

Features

• ksql-driver: Support offset earliest, replays and per partition streaming (#5663) (3a79d02)

0.31.15 (2022-11-17)

Bug Fixes

• @cubejs-backend/snowflake-driver: Make CUBEJS_DB_SNOWFLAKE_CLIENT_SESSION_KEEP_ALIVE=true by default (be12c40)
• extends YAML support (982885e)
• client-react: check meta changes (4c44551)
• druid-driver: Respect day light saving (#5613) (388c992)
• packages/cubejs-client-core/package.json to reduce vulnerabilities (#5415) (fb2de68)
• packages/cubejs-client-react/package.json to reduce vulnerabilities (#5390) (0ab9c30)
• packages/cubejs-databricks-jdbc-driver/package.json to reduce vulnerabilities (#5413) (6a891f0)
• packages/cubejs-databricks-jdbc-driver/package.json to reduce vulnerabilities (#5429) (a45c9a8)
• packages/cubejs-query-orchestrator/package.json to reduce vulnerabilities (#5409) (5e9fe68)
• packages/cubejs-templates/package.json to reduce vulnerabilities (#5403) (c9706cb)
• server-core: Force flush events if their count is greater than the agent frame size (#5602) (17d1d98)

Features

• databricks-jdbc: jdbc (jar) driver update (#5610) (aacd8cd)
• databricks-jdbc: jdbc (jar) driver update (#5612) (372ed71)
• docs: add new component to display code snippets side-by-side (146328c)
• Replace YAML parser to provide more meaningful parse errors (9984066)
• Support snake case in YAML relationship field (f20fe6b)

Reverts

• Revert "feat(databricks-jdbc): jdbc (jar) driver update (#5610)" (#5611) (23ed416), closes #5610 #5611

0.31.14 (2022-11-14)

Bug Fixes

• cubesql: Allow referencing CTEs in UNION (7f5bc83)
• cubesql: Keep CubeScan literal values relation (6d3856a)
• playground: schemaVersion updates (5c4880f)

Features

• @cubejs-backend/mssql-driver: Make MSSQL readOnly by default (#5584) (ddf0369)
• cubesql: Join Cubes (#5585) (c687e42)
• playground: ability to rerun queries (#5597) (6ef8ce9)

0.31.13 (2022-11-08)

Bug Fixes

• Make Trino driver CommonJS compatible (#5581) (ca8fd4e)
• cubestore: Merge for streaming union (#5554) (310649a)

Features

• export bucket CVS files escape symbol support (#5570) (09ceffb)
• notStartsWith/notEndsWith filters support (#5579) (8765833)
• YAML snake case and .yaml extension support (#5578) (c8af286)

0.31.12 (2022-11-05)

Bug Fixes

• Cannot read property 'apply' of undefined on missed dimension sql (#5559) (6f85096)
• YAML filter support (fb6fade)
• cubestore: Fix partition pruning (#5548) (8bc4aee)
• No column found in case non equals filter query incorrectly matched against rollup with no dimensions (#5552) (73b3203)
• TypeError: Cannot read property 'dimension' of undefined for rolling window rollup without time dimension (#5553) (03c3b6f)

Features

• Trino driver (e58c392)
• cubesql: Support Skyvia date granularities (df69d93)

0.31.11 (2022-11-02)

Bug Fixes

• @cubejs-backend/prestodb-driver: Replace double escaping in contain filter (#5529) (7870705), closes #5528
• cubestore: Fix streaming index (#5550) (061305e)

Features

• cubestore: Sealing partition (#5523) (70ee72c)

0.31.10 (2022-11-01)

Bug Fixes

• Revert back strict shown checks behavior for consistency reasons (#5551) (c3ee4e6), closes #5542

0.31.9 (2022-11-01)

Bug Fixes

• @cubejs-client/core: startsWith and endsWith to filterOperatorsForMember (#5544) (583de4a)
• You requested hidden member in case of rolling window measure is being used in a view (#5546) (c00ea43)

0.31.8 (2022-10-30)

Bug Fixes

• cubesql: Count measure type changed from u64 to i64 (#5535) (f568851)

Features

• YAML support (#5539) (29c19db)
• cubesql: Support BOOL_AND, BOOL_OR aggregate functions (#5533) (a2e6e38)
• cubesql: Support Sigma Computing number filters (f2f2abd)
• cubesql: Thoughspot - count distinct with year and month (#5450) (d44baad)

0.31.7 (2022-10-27)

Bug Fixes

• Remove empty hidden cubes from meta (#5531) (f93e851)

Features

• cubesql: Support is null, is not null in SELECT (d499c47)
• cubesql: Support Sigma Computing string filters (d18b971)

0.31.6 (2022-10-20)

Bug Fixes

• docker: Correct lock for deps with yarn.lock (#5509) (97ca524)

Features

• snowflake-driver: Upgrade snowflake-sdk (#5508) (2863a93)

0.31.5 (2022-10-20)

Bug Fixes

• cubesql: Use real database name in Postgres meta layer (031a90f)

Features

• cubesql: Allow EXTRACT field to be parsed as a string (cad1e0b)
• cubestore: CC-1133 - add headers to telemetry request (#5473) (26fa817)
• pre-aggregations build jobs API endpoint (#5251) (4aee3ef)

0.31.4 (2022-10-13)

Bug Fixes

• cubestore: Extension planner for LogicalAlias error (#5459) (8153459)
• druid-driver: query timezone fix (#5372) (ccad5fc)

Features

• shown flag for cubes and views (#5455) (e7ef446)

0.31.3 (2022-10-08)

Bug Fixes

• drivers imports alignment (#5448) (ab12426)

0.31.2 (2022-10-08)

Bug Fixes

• Added connection test completed successfully log (#5444) (a8e1180)
• Temp tables dropped for ksql after successfully created (#5445) (7726c82)
• cubesql: Handle Panic on simple query executiony (#5394) (84dc442)

Features

• mssql-driver: add column type mapping for a bit type (#5442) (0ed7ba4)
• Includes and Excludes directives for Cube Views (#5437) (7c35604)
• cubesql: Support boolean decoding in pg-wire (#5436) (4fd2ee6)

0.31.1 (2022-10-04)

Bug Fixes

• Cube not found for path due to FILTER_PARAMS are used in members (#5417) (bfe76bf)
• extensions: fix SELECT handling in the Funnels extensions (#5397) (041f591)
• playground: bar chart pivot config (36b9ec2)

Features

• console-ui: show error stack trace (7ab15c6)

0.31.0 (2022-10-03)

• feat!: Cube Views implementation (#5278) (9937356), closes #5278

Bug Fixes

• cubesql: Allow derived tables to have a dot in column name (#5391) (f83009c)
• cubesql: cast strings to timestamp (#5331) (a706258)
• cubesql: Metabase - substring __user (#5328) (a25c8bf)
• cubesql: udf format_type prepared statement fix (#5260) (307ed1b)
• cubesql: WHERE Lower / Upper in list with multiply items (#5376) (2269b2b)
• cubestore: Aggregate function MERGE not allowed for column type bytes (#5166) (7626ed5)
• cubestore: Fix error: Internal: channel closed on the next request after cubestore cloud process got OOM (#5238) (cb81fdb)
• postgres-driver: release method should not throw (#5395) (9423f46)
• query-orchestrator: pre-aggs build range queries cache key alignment (#5377) (5896c4a)
• schema-compiler: throw an error for the empty pre-aggs (#5392) (4afd604)

Features

• cubesql: Holistics - in dates list filter (#5333) (94b6509)
• cubesql: Support joins with distinct (#5340) (da4304f)
• multiple data source (#5326) (334af8c)
• cubesql: Add float8, bool casts (b345ade)
• cubesql: Allow char_length function to be used with cubes (e99344f)
• cubesql: Allow filter by exact year (Tableau) (#5367) (c31e59d)
• cubesql: Holistics - support range of charts (#5325) (d16b4c2)
• cubesql: Support date_trunc over column filter with <= (b30d239)
• query-orchestrator: introduce unload without temp table (#5324) (3dcbd2e)
• testing: databricks test suite (#5311) (b77f33b)

BREAKING CHANGES

• The logic of how cubes are included in joins has been changed. There are multiple member reference constructs that are now forbidden and should be rewritten. You can't reference foreign cubes anymore to define members inside other cubes: ${ForeignCube}.foo. foo member should be defined in ForeignCube and referenced as ${ForeignCube.foo}. You also can't mix references and members without CUBE self-reference. For example ${ForeignCube.foo} + bar is invalid and ${ForeignCube.foo} + ${CUBE}.bar should be used instead. If not fixed, it'll lead to missing tables in the FROM clause.

0.30.75 (2022-09-22)

Bug Fixes

• Cannot read 'map' property of undefined for rollupLambda in BigQuery (47f700f)
• Invalid identifier day for month lambdaRollup (#5338) (bacc643)
• cubesql: Allow interval sum chaining (eabbdc2)
• databricks-driver: using the ILIKE operator in the DatabricksFilter.likeIgnoreCase method (#5334) (a81ca35)