cube

0.31.38 (2023-01-11)

Bug Fixes

• athena-driver: Add catalog config (#5835) Thanks @tkislan ! (c33a5c5)
• athena-driver: TypeError: table.join is not a function (#5988) (4e56a04), closes #5143
• Delete CUBEJS_DROP_PRE_AGG_WITHOUT_TOUCH pre-aggregations only after refresh end to avoid cold start removals (#5982) (58ad02f)

Features

• cubesql: Improve memory usage in writting for pg-wire (#4870) (401fbcf)
• docker: Upgrade Node.js to 14.21.1 (#5970) (0394ed2)

0.31.37 (2023-01-09)

Bug Fixes

• Remove missed cacheFn console.log (ec9e56b)

Features

• cubejs-api-gateway: added endpoint to run sql query directly (#5786) (61d5798)
• cubestore: Support lazy initialization for CacheStore (#5933) (37b4a95)

0.31.36 (2023-01-08)

Bug Fixes

• graphql non capital cube name issue (#5680) Thanks @MattFanto! (47956ea), closes #5643
• Potential OOM due to recursion while recovering Cube Store websocket (8a0fd1f)

Features

• cubestore: Set metastore current snapshot system command (#5940) (f590a20)

0.31.35 (2023-01-07)

Bug Fixes

• client-core: Added type CubesMap for cubeMap in Meta (#5897) (92d1ccb)
• cubestore: Get query execution results even after web socket disconnect (#5931) (c6ccc1a)
• cubestore: Maintain minimum count of metastore snapshots (#5925) (b303aa6)
• Reduce memory footprint for pre-aggregations with many partitions by caching partition SQL (5f72d8f)

Features

• cubejs-cli: add type-checking for cube.js files to newly-generated projects (ba31d4f)
• cubesql: Support NULLIF in projection (129fc58)
• cubesql: Support Thoughtspot starts/ends LIKE exprs (e6798cc)

0.31.34 (2023-01-05)

Bug Fixes

• client-core: move @babel/runtime to dependencies (#5917) (67221af)
• Reuse queries cache in refresh worker pre-aggregation iterator to reduce memory usage in high concurrency environment (4ae21fa)

0.31.33 (2023-01-03)

Bug Fixes

• @cubejs-client/core: add missing Series.shortTitle typing (#5860) (5dd78b9)

Features

• cubesql: Support Node.js 18 (#5900) (839fa75)
• Introduce CubeStoreCacheDriver (#5511) (fb39776)

0.31.32 (2022-12-28)

Features

• cubesql: Allow postprocessing with JOIN below Cube query limit (56f5399)
• cubesql: Support LEFT, RIGHT in projection (282ad3a)
• cubestore: Direct kafka download support for ksql streams and t… (#5880) (fcb5c5e)
• cubestore: Installer - download binary without GH API (#5885) (51a0f39)

0.31.31 (2022-12-23)

Bug Fixes

• cubesql: Improve Thoughtspot WHERE IN support (6212efe)
• cubesql: Support Thoughtspot DATEADD queries (58b5669)

Features

• cubestore-driver: Introduce CUBEJS_CUBESTORE_NO_HEART_BEAT_TIMEOUT env (e67e800)
• cubestore: Initial support for KV cache (#5861) (498d4b5)
• playground: allow for query renaming (#5862) (681a2d8)

0.31.30 (2022-12-22)

Bug Fixes

• cubesql: Improve Thoughtspot compatibility (4d6511a)
• cubestore-driver: Increase retry timeout to avoid endless loop connection retries (8bd19fa)
• Pre-aggregation table is not found after it was successfully created for CUBEJS_DROP_PRE_AGG_WITHOUT_TOUCH strategy (#5858) (f602fee)

Features

• @cubejs-client/core: expose shortTitle in seriesNames (#5836) Thanks @euljr ! (1058d5a)

0.31.29 (2022-12-18)

Bug Fixes

• Error: WebSocket is not open: readyState 2 (CLOSING) (#5846) (a5be099)

0.31.28 (2022-12-16)

Features

• Support string, time and boolean measures (#5842) (4543ede)

0.31.27 (2022-12-16)

Bug Fixes

• api-gateway: pre-aggregations/jobs auth middleware (#5840) (b527cd9)

0.31.26 (2022-12-13)

Bug Fixes

• cubestore: Temporary disable compression to check if it fixes running on Mac OS X Ventura (8e89427), closes #5712
• trino-driver: Timezone issue fix (#5731) Thanks @yuraborue ! (70df903)

Features

• cubestore: Introduce pre-aggregation table touch and allow to drop tables without touch using CUBEJS_DROP_PRE_AGG_WITHOUT_TOUCH env (#5794) (ad6c1e8)
• persistent queue (#5793) (02a8e02)

0.31.25 (2022-12-10)

Bug Fixes

• cubesql: normalize column names in filter node (#5788) (28aa008)

0.31.24 (2022-12-09)

Bug Fixes

• cubesql: Support CAST in HAVING clause (17ba3e2)

Features

• api-gateway, server-core: Added dataSources list to extended meta (#5743) (2c5db32)

Reverts

• Revert "feat(api-gateway, server-core): Added dataSources list to extended meta (#5743)" (#5785) (3c61467), closes #5743 #5785
• Revert "chore(cubejs-api-gateway): added endpoint to run sql query directly (#5723)" (#5784) (f1140de), closes #5723 #5784

0.31.23 (2022-12-09)

Bug Fixes

• jdbc-driver: set default encoding (#5773) (734167a)

Features

• query limits (#5763) (4ec172b)
• cubesql: Support CASE statements in cube projection (e7ae68c)
• introducing query persistent flag (#5744) (699e772)

0.31.22 (2022-12-07)

Bug Fixes

• cubesql: Metabase - auto-generated charts for cubes containing string dimensions (#5728) (72be686)
• cubestore: Added long running job fetches burst network (385c4a6)
• cubestore: Increase default stale stream timeout to allow replays to catch up with large kafka streams (43cf0b1)
• cubestore: Row with id 1 is not found for SchemaRocksTable -- fix log replay order during metastore loading from dump (b74c072)
• playground: reload the page in case chunks got stale (#5646) (2215595)
• return failed query request ids (#5729) (22cd580)

Features

• playground: yaml rollup support (#5727) (7a267f9)

0.31.21 (2022-12-06)

Bug Fixes

• cubestore: Error in processing loop: Row with id is not found for JobRocksTable for streaming jobs (f2de503)
• cubestore: Avoid streaming jobs waiting for regular jobs to complete (#5725) (89d5bf4)
• cubestore: Chunk all streaming input into bigger chunks based on time spent in write chunk operations and remove sequence gap checks as those fail for tables (1f2d9bf)
• cubestore: Replay streams with earliest offset even for latest setting after failure (7ca71f5)
• cubestore: ReplayHandle reconcile fails due to merge ReplayHandles with Chunks (#5713) (ac213a7)
• cubestore: Streaming jobs stuck as stale (1cf3432)
• databricks-jdbc: Databricks pre-aggregations schema with UC (#5726) (6281471)
• playground: clear search value (#5720) (5b177f2)
• More explanatory No pre-aggregation partitions were built yet message (#5702) (ec39baa)

0.31.20 (2022-12-02)

Bug Fixes

• clickhouse-driver: Make ClickHouse driver readOnly by default (e6a85d1), closes #5479
• clickhouse-driver: ParserError("Expected ',' or ')' after column definition, found: (") when Nullable(Float64) is present (81b2247)
• cubesql: Fix escape symbols in LIKE expressions (5f3cd50)
• cubestore: Orphaned replay handles after table drop (0e4b876)
• cubestore: Sort by seq column to reduce Unexpected sequence increase gap (b5f06d0)
• oracle-driver: Make oracle driver readOnly by default so pre-aggregations can be used (5efccba)

Features

• cubesql: Support Thoughtspot include filter search (745fe5d)
• cubesql: Support ThoughtSpot search filters (ee0fde4)

0.31.19 (2022-11-29)

Bug Fixes

• Incorrect filter pushdown when filtering two left-joined tables (#5685) (c775869), closes #3777
• packages/cubejs-client-core/package.json to reduce vulnerabilities (#5352) (76e8e43)
• packages/cubejs-client-vue/package.json to reduce vulnerabilities (#5361) (effc694)
• packages/cubejs-query-orchestrator/package.json to reduce vulnerabilities (#5347) (3442ddf)
• packages/cubejs-schema-compiler/package.json to reduce vulnerabilities (#5359) (cd81554)
• packages/cubejs-schema-compiler/package.json to reduce vulnerabilities (#5408) (6b7a95f)
• packages/cubejs-templates/package.json to reduce vulnerabilities (#5342) (825605a)

Features

• catalog support for the Databricks driver (#5666) (de5ba9a)