cube

0.28.58 (2021-11-18)

Bug Fixes

• @cubejs-backend/clickhouse-driver: clickhouse joins full key query aggregate fails (#3600) Thanks @antnmxmv! (c6451cd), closes #3534
• cubesql: Parsing error with single comment line (a7697c1)
• cubestore: Error during planning: The field has has qualifier for UNION query with IN (#3697) (01a6d6f), closes #3693

Features

• cubesql: Casting to date on compare with time dimension (8bc7b26)
• cubesql: Strict check for dates in BETWEEN operator (329da03)
• cubesql: Support DATE_TRUNC(string, column) (#3677) (e4e9b4e)
• gateway: GraphQL endpoint (#3555) Thanks @lvauvillier! (ed85192), closes #3433

0.28.57 (2021-11-16)

Bug Fixes

• cubesql: Support identifier escaping in h/m/s granularaties (1641b69)

Features

• cubesql: Initial support for INFORMATION_SCHEMA (d1fac9e)
• cubesql: Support schema() (3af3c84)
• cubesql: Support SHOW WARNINGS (73d91c0)
• cubesql: Support USER(), CURRENT_USER() (8a848aa)

0.28.56 (2021-11-14)

Bug Fixes

• cubestore: Drop not ready tables 30 minutes after creation to avoid metastore bloating (e775682)
• cubestore: Invalidate tables cache only on table changing operations to reduce write lock contention (28549b8)
• cubestore: Replace all_rows access with scans to optimize allocations (ab985c8)

0.28.55 (2021-11-12)

Bug Fixes

• cubestore: fix float comparisons causing unsorted data in merges (c5b5d2c)
• cubestore: Timeout for create table finalization (d715345)
• JSON.stringify schema version instead of calling .toString() to simplify usage with objects (50a191e)
• cubestore: Do not fail swap_chunks with assert -- allow to gracefully capture error (8c8b6eb)
• cubestore: Do not fail on repartition of empty chunks (41b3054)
• cubestore: speed up HLL++ merges, up to 180x in some cases (24ecbc3)
• cubestore: system.tables can affect table visibility cache by including non ready tables. Ignore delete middle man reconciliation errors. (dce711f)

Features

• Introduce checkSqlAuth (auth hook for SQL API) (3191b73)

0.28.54 (2021-11-09)

Bug Fixes

• @cubejs-backend/snowflake-driver: Do not trigger cluster start on test connection (3bb2d8f)
• cubestore: Introduce file suffixes to avoid parquet write clashes in case of meta store recovery (#3639) (4d01e8b)
• cubestore: Row with id is not found for PartitionRocksTable. Repartition not active partitions on reconcile. Do not drop orphaned jobs that weren't scheduled. Repartition only limited amount of rows during single repartition job. (#3636) (55bbc60)

Features

• cubestore: System tables and commands for debugging (#3638) (22650a1)

0.28.53 (2021-11-04)

Bug Fixes

• playground: displaying boolean values (76396ea)
• TypeError: Cannot read property 'joins' of null in case of queryRewrite returns empty query (#3627) (d880d0c)

Features

• cubesql: Real connection_id (24d9804)
• cubesql: Specify MySQL version as 8.0.25 in protocol (eb7e73e)

0.28.52 (2021-11-03)

Bug Fixes

• client-core: dayjs global locale conflict (#3606) Thanks @LvtLvt! (de7471d)
• cubesql: MYSQL_TYPE_STRING for Booleans was null (fcdd8f5)
• Empty data partitioned pre-aggregations are incorrectly handled -- value provided is not in a recognized RFC2822 or ISO format (9f3acd5)
• packages/cubejs-query-orchestrator/package.json to reduce vulnerabilities (#3281) (a6a62ea)

Features

• cubeclient: Granularity is an optional field (c381570)
• cubesql: Execute SHOW DATABASES from AST (cd2b4ac)
• cubesql: Improve filter pushing (dateRange -> timeDimension) and segment (8d7ea9b)
• cubestore: partitioned indexes for faster joins (8ca605f)

0.28.51 (2021-10-30)

Bug Fixes

• Prevent mutation pre-aggregation objects, debug API (#3605) (0f982ce)
• cubejs-client-ngx: FilterMember.replace() will no longer update all filters with replacement (#3597) (f972ad3)
• native: warning - is missing a bundled dependency node-pre-gyp (0bee2f7)

Features

• cubesql: Skip SET = (616023a)
• cubesql: Support db(), version() via QE (5a289e1)
• cubesql: Support system variables (#3592) (d2bd1fa)
• cubesql: Use real Query Engine for simple queries (cc907d3)

0.28.50 (2021-10-28)

Bug Fixes

• @cubejs-backend/mysql-driver: Handle utf8mb4_bin as string (a897392)
• cubestore: Added CUBESTORE_META_BIND_ADDR and CUBESTORE_WORKER_BIND_ADDR to allow for IPv6 binds (435f8fc)
• cubestore: assertion failed: (left == right) in case of trying to access table streaming table right after creation (c900d51)
• native: Correct logging level for native module (c1a8439)

Features

• native: Simplify filters while converting to JSON RPC (acab66a)
• Validate return type for dbType/driverFactory/externalDriverFactory in runtime (#2657) (10e269f)

0.28.49 (2021-10-23)

Bug Fixes

• @cubejs-backend/server-core: Clean fetching pre-aggregation ranges, debug API (#3573) (7beb090)
• cubesql: Correct LE (<), GT (>) handling for DateTime filtering (55e805a)

0.28.48 (2021-10-22)

Bug Fixes

• Use BaseQuery#evaluateSql() for evaluate refresh range references, pre-aggregations debug API (#3352) (ea81650)
• @cubejs-backend/ksql-driver: Missing in docker (4af6c8a)
• @cubejs-backend/ksql-driver: Scaffolding for empty schema generates empty prefix (091e45c)
• @cubejs-backend/ksql-driver: Unquoted describe (61dba66)

Features

• cubesql: EXPLAIN (debug info) (7f0b57f)

0.28.47 (2021-10-22)

Bug Fixes

• diagnostics - cannot convert undefined or null to object (#3564) (643c9f8)

Features

• ksql support (#3507) (b7128d4)
• cubesql: Simplify root AND in where (a417d4b)
• cubesql: Support SHOW DATABASES (alias) (f1c4d3f)
• playground: placeholder for BI (refers to documentation) (#3563) (6b7da77)

0.28.46 (2021-10-20)

Bug Fixes

• update error message for join across data sources (#3435) (5ad72cc)
• @cubejs-backend/snowflake-driver: escape date_from and date_to in generated series SQL (#3542) Thanks to @zpencerq ! (858b7fa), closes #3215
• native: Catch errors in authentication handshake (msql_srv) (#3560) (9012399)
• schema-compiler: assign isVisible to segments (#3484) Thanks to @piktur! (53fdf27)

Features

• prestodb-driver: Bump prestodb-client (08e32eb)
• prestodb-driver: Support SSL (b243e9f)

0.28.45 (2021-10-19)

Note: Version bump only for package cubejs

0.28.44 (2021-10-18)

Bug Fixes

• native: Compile under Debian 9 (minimize libc requirement) (9bcfb34)

Features

• native: Enable logger (f0e2812)

0.28.43 (2021-10-17)

Bug Fixes

• native: Allow to install Cube.js on unsupported systems (71ce6a4)
• native: Split musl/libc packages (musl is unsupported for now) (836bd5f)

Features

• native: Support windows (287665b)

0.28.42 (2021-10-15)

Bug Fixes

• cubesql: SET NAMES utf8mb4 (9229123)
• postgres-drive: Move cubejs-backend/testing to devDep (reduce size) (a3667c6)

Features

• native: CubeSQL - support auth via JWT (from user) (#3536) (a10bd59)
• playground: Support react chartjs charts drilldowns (#3500) (499e37e)
• Integrate SQL Connector to Cube.js (#3544) (f90de4c)

0.28.41 (2021-10-12)

Bug Fixes

• @cubejs-backend/snowflake-driver: Reduce memory usage during batching downloads (8748344)
• cubestore: fix parquet statistics for string columns (565465a)
• cubestore-driver: Use ILIKE for contains filter (#3502) (c1b2e10)

Features

• Introduce @cubejs-backend/native 🦀 (#3531) (5fd511e)
• Introduce cubeclient (rust client) (ff44347)
• Introduce SQL Connector for Cube.js 🚀 (#3527) (7d97398)

0.28.40 (2021-09-30)

Bug Fixes

• Count distinct by week matches daily rollup in case of data range is daily (#3490) (2401418)
• @cubejs-backend/schema-compiler: check segments when matching pre-aggregations (#3494) (9357484)
• @cubejs-backend/schema-compiler: CubePropContextTranspiler expli… (#3461) (2ae7f1d)
• @cubejs-backend/schema-compiler: match query with no dimensions … (#3472) (2a5dd4c)

Features

• docker: Use Node 12.22.6 (9de777c)

0.28.39 (2021-09-22)

Bug Fixes

• @cubejs-client/vue: catch dryRun errors on query-builder mount (#3450) (189491c)
• cubestore: fix Docker Hub repository name (14cd0c3)
• cubestore: fix string-to-timestamp conversion (654e81d)
• cubestore: invalid data after compaction of binary columns (064a9f4)
• postgres-driver: Unable to detect type for field "@parser" (#3475) (3e70d47)