cube

0.29.55 (2022-05-04)

Bug Fixes

• cubesql: Correct handling for boolean type (cff6c8b)
• cubesql: Tableau new regclass query fast fix (2a7ff1e)

Features

• cubesql: Tableau cubes without count measure support (931e2f5)

0.29.54 (2022-05-03)

Bug Fixes

• Disable UPX compressing for Cube Store arm64-linux-gnu, fix #4474 (#4476) (3cb8586)
• Make dimensions and measures nullable fields for GraphQL API (#4477) Thanks @MarkLyck ! (84e298e), closes #4399
• cubesql: Using same alias on column yields Option.unwrap() panic (a674c5f)
• Prestodb timestamp cast to work in prestodb and athena (#4419) Thanks @apzeb ! (8f8f61a), closes #4221

Features

• cubejs: rollupJoin between multiple databases (#4371) (6cd77d5)
• cubesql: Tableau boolean filters support (33aa5f1)
• cubesql: Tableau cast projection queries support (71ec644)
• cubesql: Tableau contains support (71dcad0)
• cubesql: Tableau min max number dimension support (2abe13e)
• cubesql: Tableau not null filter support (d48d0e0)
• cubesql: Tableau week support (6d987ea)
• Detailed client TS types (#4446) Thanks @reify-thomas-smith ! (977cce0), closes #4202

0.29.53 (2022-04-29)

Bug Fixes

• @cubejs-client/core: Correct LogicalAndFilter/LogicalOrFilter types: allow any filter types in and / or (#4343) Thanks @tchell ! (699a2f4)
• @cubejs-client/core: fix HTTP poll not working if Cube API stops and recovers (#3506) Thanks @rongfengliang ! (c207c3c)
• cubejs-playground: fix history header scrolling in graphql explorer (#4410) (a8b82b5)
• cubesql: fix pg_constraint confkey type (#4462) (82c25fd)
• cubestore: Index selection for different permutations of columns in a group by omits sorted indexes (#4455) (fb31edd)
• playground: change the url on query change (5c59298)

Features

• @cubejs-client/core: Accept immutable queries (#4366) Thanks @reify-thomas-smith! (19b1514), closes #4160
• client-core: Add HTTP status code to RequestError (#4412) (6ec4fdf)
• client-vue: boolean filters support (#4314) (8a3bb3d)
• cubesql: Aggregate aggregate split to support Tableau extract date part queries (532b4ee)
• cubesql: Projection aggregate split to support Tableau casts (#4435) (1550774)
• cubesql: Support for pg_get_userbyid, pg_table_is_visible UDFs (64f8885)
• cubesql: Support generate_subscripts UDTF (a29551a)
• cubesql: Support get_expr query for Pg/Tableau (#4421) (4d4918f)
• cubesql: Support information_schema._pg_expandarray postgres UDTF (#4439) (1af4290)
• cubesql: Support pg_catalog.pg_am table (24b231d)
• cubesql: Support Timestamp, TimestampTZ for pg-wire (0b38b3d)
• cubesql: Support unnest UDTF (110bdf8)
• cubesql: Tableau default having support (4d432c0)
• cubesql: Tableau Min, Max timestamp queries support (48ee34e)
• cubesql: Tableau range of dates support (ef56133)
• cubesql: Tableau relative date range support (87a3817)
• cubesql: Unwrap filter casts for Tableau (0a39420)
• packages: Materialize driver (#4320) (d40d13b)
• playground: display error stack traces (#4438) (0932cda)

0.29.52 (2022-04-23)

Note: Version bump only for package cubejs

0.29.51 (2022-04-22)

Bug Fixes

• cubesql: Bool encoding for text format in pg-wire (7faf34b)
• cubesql: current_schema() UDF (69a75dc)
• cubesql: Proper handling for Postgresql table reference (35f5635)
• playground: chart templates (#4426) (ebc83a9)

Features

• cubesql: Correlated subqueries support for introspection queries (#4408) (1f02b2c)
• cubesql: Implement rewrites for SELECT * FROM WHERE 1=0 (#4427) (0c9abd1)
• cubesql: Support arrays in pg-wire (b7925ba)
• cubesql: Support generate_series UDTF (#4416) (3321925)
• cubesql: Support GetIndexedFieldExpr rewrites (#4424) (8dca8b5)
• cubesql: Support information_schema._pg_datetime_precision UDF (4d20ee6)
• cubesql: Support information_schema._pg_numeric_precision UDF (6fc6c0a)
• cubesql: Support information_schema._pg_numeric_scale UDF (398d1db)
• cubesql: Support lc_collate for PostgreSQL (120ce31)
• cubesql: Support NoData response for empty response in pg-wire (6711c8a)
• cubesql: Support pg_get_expr UDF (#4425) (2b51d70)
• cubesql: Support pg_get_userbyid UDF (c6efef8)
• cubesql: Use proper command completion tags for pg-wire (3e777ec)
• databricks-driver: Export bucket support for S3/Azure (#4430) (4512126)
• query-language: "startsWith", "endsWith" filters support (#4128) (e8c72d6)

0.29.50 (2022-04-18)

Bug Fixes

• playground: match rollup button (#4401) (18e90bb)

Features

• cubesql: Initial support for Binary format in pg-wire (a36845c)
• cubesql: Support Describe(Portal) for pg-wire (34cf111)
• cubesql: Support pg_depend postgres table (ceb35d4)

0.29.49 (2022-04-15)

Bug Fixes

• athena: Support plain bucket for CUBEJS_DB_EXPORT_BUCKET (#4390) (4b4dd60)
• mssql: Add uniqueidentifier type support -- Custom type 'uniqueidentifier' is not supported (#4386) Thanks @jdeksup! (fb77332)

0.29.48 (2022-04-14)

Bug Fixes

• cubesql: Support pg_catalog.format_type through fully qualified name (9eafae0)
• cubestore: Empty CUBESTORE_S3_SUB_PATH leads to can't list file error (#4324) (0b35064)
• cubestore: Inactive partition compaction: replace error with warn (#4337) (2ad61ee)
• cubestore: Support a space separated binary strings for HyperLogLog fields in csv -- Can't parse column value for countDistinctApprox in Athena (#4383) (8b320b6)

Features

• cubesql: Initial support for prepared statements in pg-wire (#4244) (912b52a)
• query-language: "total" flag support (#4134) (51aef5e)
• Support Compound Primary Keys (#4370) Thanks @rccoe! (0e3983c), closes #4364
• cubesql: Postgres Apache Superset connection flow support (ab256d9)

0.29.47 (2022-04-12)

Bug Fixes

• cubesql: Correct MySQL types in response headers (#4362) (c507f82)
• cubesql: Special handling for bool as string (3ba27bf)
• cubesql: Support boolean (ColumnType) for MySQL protocol (23f8367)

0.29.46 (2022-04-11)

Bug Fixes

• cubesql: Rewrite engine decimal measure support (8a0fa98)

Features

• cubesql: Support format_type UDF for Postgres (#4325) (8b972ca)

0.29.45 (2022-04-09)

Bug Fixes

• cubesql: Rewrite engine datafusion after rebase regressions: mismatched to_day_interval signature, projection aliases, order by date. (8310f7e)

0.29.44 (2022-04-07)

Note: Version bump only for package cubejs

0.29.43 (2022-04-07)

Bug Fixes

• cubesql: Rewrites don't respect projection column order (cfe35a7)
• cubestore: Filters aren't included in index choosing (c582622)

Features

• cubesql: Rewrite engine error handling (3fba823)
• cubesql: Upgrade rust to 1.61.0-nightly (2022-02-22) (c836065)
• cubestore: Add CUBEJS_GH_API_TOKEN env var to download script (#4282) Thanks @icebob! (ac57162)
• cubestore: Explain implementation (#4303) (53fe3f3)

0.29.42 (2022-04-04)

Bug Fixes

• @cubejs-backend/snowflake-driver: Download numbers with 0 scale as integers in pre-aggregations (42eb582)
• cubesql: Allow quoted variables with SHOW syntax (#4313) (3eece0e)
• playground: adding a query parameter in Playground requires one extra click to type in search field (#4295) (4abab96)
• playground: rollup designer count distinct warning (#4309) (add2dd3)
• playground: transparency under the searchbar in some cases (#4301) (6cdb20c)

Features

• cubesql: Rewrite engine segments support (48b0767)

0.29.41 (2022-04-03)

Bug Fixes

• jdbc-driver: Handle mvn error for empty java dependencies (#4307) (9e12511)

0.29.40 (2022-04-03)

Bug Fixes

• cubesql: Table columns should take precedence over projection to mimic MySQL and Postgres behavior (60d6e45)

Features

• cubestore: IN operator support for decimal type (#4306) (d728163)

0.29.39 (2022-04-01)

Bug Fixes

• native: Post installation issue with npm (avoid bundledDependencies) (6163838)

0.29.38 (2022-04-01)

Bug Fixes

• cubesql: Deallocate statement on specific command in MySQL protocol (ab3f36c)
• cubesql: Enable EXPLAIN support for postgres (c0244d1)
• cubestore: Add compaction and chunk writing guards to cleanup uploads folder on any failures to minimize storage bloating (b6e79fa)
• native: Post installation issue with npm (#4302) (8aa9c71)

Features

• cubesql: Initial support for current_schemas() postgres function (e0907ff)
• cubesql: Postgres pg_catalog.pg_class MetaLayer table (#4287) (d70da08)
• cubesql: Support binding values for prepared statements (MySQL only) (ad26dc5)
• cubesql: Support current_schema() postgres function (44b64ce)
• cubesql: Support information_schema.character_sets (postgres) table (1804b79)
• cubesql: Support information_schema.key_column_usage (postgres) table (84cf2c1)
• cubesql: Support information_schema.referential_constraints (postgres) table (eeb42be)
• cubesql: Support information_schema.table_constraints (postgres) table (2d6bfee)
• cubesql: Support pg_catalog.pg_description and pg_catalog.pg_constraint MetaLayer tables (#4292) (0ea9699)
• MySQL SET variables / Postgres SHOW SET variables (#4266) (88ec3cc)
• cubesql: Postgres pg_catalog.pg_proc MetaLayer table (#4289) (b3613d0)
• cubesql: Support pg_catalog.pg_attrdef table (d6aae8d)
• cubesql: Support pg_catalog.pg_attribute table (d5f7d0c)
• cubesql: Support pg_catalog.pg_index table (a621532)

0.29.37 (2022-03-29)

Bug Fixes

• cubesql: Dropping session on close for pg-wire (#4280) (c4442be)
• cubesql: Rewrite engine: support for stacked time series charts (c1add2c)
• packages/cubejs-bigquery-driver/package.json to reduce vulnerabilities (#3924) (e44ca40)
• cubesql: Rewrite engine can't parse db prefixed table names (b7d9382)

Features

• @cubejs-backend/schema-compiler: Allow filtering with or/and in FILTER_PARAMS (#4253) Thanks @tchell! (cb1446c)
• cubesql: Global Meta Tables (88db9ea)
• cubesql: Global Meta Tables - add tests (42e9517)
• cubesql: Global Meta Tables - cargo fmt (c8336d9)
• cubesql: Support pg_catalog.pg_range table (625c03a)
• Introduce CUBEJS_ALLOW_UNGROUPED_WITHOUT_PRIMARY_KEY env (#2941) Thanks @vignesh-123 ! (fa829bf)

0.29.36 (2022-03-27)

Features

• cubesql: Improve Postgres, MySQL meta layer (#4228) (5c8d002)
• cubesql: Rewrite engine first steps (#4132) (84c51ed)
• cubesql: Support pg_catalog.pg_namespace table (66e41da)
• cubesql: Support pg_catalog.pg_type table (d792bb9)