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)

0.30.74 (2022-09-20)

Features

• cubesql: Support LOWER(?column) IN (?literal) (#5319) (2e85182)

0.30.73 (2022-09-19)

Features

• cubesql: Increase limits for statements/portals/cursors (#5146) (363b42d)

Reverts

• Revert "feat: strategy without creating temp table (#5299)" (0a3d646), closes #5299

0.30.72 (2022-09-18)

Bug Fixes

• cubestore: Immediately restart stale streaming jobs to avoid processing gaps for sparse streams (60075af)

Features

• Introduce rollupLambda rollup type (#5315) (6fd5ee4)
• strategy without creating temp table (#5299) (8e8f500)
• cubesql: starts_with, ends_with, LOWER(?column) = ?literal (#5310) (321b74f)

0.30.71 (2022-09-16)

Bug Fixes

• @cubesj-backend/databricks-driver: Incorrect escaping of CSV passed to Cube Store -- Can't parse timestamp errors (21b139c)

Features

• cubesql: Holistics - string not contains filter (#5307) (3e563db)
• cubesql: Support filtering date within one granularity unit (427e846)
• cubesql: Support startsWith/endsWidth filters (QuickSight) (#5302) (867279a)

0.30.70 (2022-09-14)

Features

• cubejs-docker: latest-jdk image added to the release cycle (#5288) (155076a)

0.30.69 (2022-09-13)

Bug Fixes

• cubesql: LOWER(__user) IN (?literal) (ThoughtSpot) (#5292) (0565a16)
• databricks-driver: remove env user agent (#5286) (cb903bb)
• snowflake-driver: added agent (#5273) (3a231fb)
• migrate base driver to ts (#5233) (c24f545)

Features

• base-driver: Split BaseDriver to @cubejs-backend/base-driver (#5283) (ca7f9d2)
• cubesql: Holistics - support range of charts (#5281) (f52c682)
• cubesql: Support pg_catalog.pg_stats meta layer table (f2a1da2)

0.30.68 (2022-09-09)

Features

• cubesql: Support IN for __user (ThoughtSpot) (#5269) (d9aaefc)
• cubesql: Support interval multiplication (bb2e82a)

0.30.67 (2022-09-09)

Bug Fixes

• freeze node.js dependencies for images (#5270) (7ea053e)
• cubesql: Show MEASURE() instead of NUMBER() in measure aggregation type doesn't match error. (#5268) (a76059e)
• schema-compiler: messed order in sub-query aggregate (#5257) (a6ad9f6)

Features

• cubesql: Holistics - GROUP BY dates support (#5264) (7217950)
• testing: driver test suite (#5256) (2e94ec5)

0.30.66 (2022-09-08)

Bug Fixes

• driver's constructor parameters initializers (#5258) (08324a5)

0.30.65 (2022-09-07)

Bug Fixes

• cubestore: Fix 'no such file or directory' after cubestore restart (#5247) (efaf897)

Features

• cubesql: Holistics - support in subquery introspection query (#5248) (977a251)
• cubesql: Holistics - support left join introspection query (#5249) (455d31f)
• docker: Install CrateDB driver (#5252) (40fdfd6)

0.30.64 (2022-09-07)

Bug Fixes

• cubesql: select column with the same name as table (#5235) (1a20f6f)

Features

• cubesql: Holistics - support schema privilege query (#5240) (ae59ddf)
• cubesql: Support nullif with scalars (#5241) (138dcae)
• cubesql: Support yearly granularity (ThoughtSpot) (#5236) (416ddd8)

0.30.63 (2022-09-05)

Bug Fixes

• databricks-driver: add deprecation of token in jdbc connection string (#5208) (e59d72c)
• query-orchestrator: delete temp tables (#5231) (a39944a)

0.30.62 (2022-09-02)

Features

• cubesql: Superset - serverside paging (#5204) (dfd695d)
• cubesql: Support dow granularity (ThoughtSpot) (#5172) (0919e40)
• cubesql: Support doy granularity (ThoughtSpot) (#5232) (be26775)

0.30.61 (2022-09-01)

Bug Fixes

• Correct error message when no pre-aggregation partitions were built and API instance accessing those (82f2378)

Features

• cubesql: Eliminate literal filter (true or true = true) (#5142) (7a6f8f9)
• cubesql: Improve support (formats) for TO_TIMESTAMP function (#5218) (044c3e1)
• cubesql: Push down limit through projection (#5206) (3c6ff7d)
• cubesql: Support LOCALTIMESTAMP (0089a65)

0.30.60 (2022-08-28)

Bug Fixes

• cubestore: Read an inline table only on the assigned worker (#5147) (15c2aa0)

0.30.59 (2022-08-26)

Bug Fixes

• cubesql: Persist dbname from connection for pg-wire (#5165) (6bdf5df)
• cubestore-driver: Correct syntax for string cast (#5160) (961a2f2)

Features

• cubestore: Support Cast from timestamp to string (#5163) (651a584)

0.30.58 (2022-08-25)

Bug Fixes

• @cubejs-backend/cubestore-driver: Aggregate function MERGE not allowed for column type bytes (#5164) (6cf5ad2)
• @cubejs-backend/cubestore-driver: ParseError "Expected (, found: ..." (6ed62ae)

Features

• cubesql: Support qtr granularity in DateTrunc for analytics queries (#5159) (ce13846)