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.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.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.74 (2022-09-20)

Features

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

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.60 (2022-08-28)

Bug Fixes

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

0.30.46 (2022-08-10)

Bug Fixes

• @cubejs-client/vue3: fix removeOffset warning (#5082) (#5083) (e1d427b)
• client-core: Fix a type inference failure (#5067) (794708e)
• cubestore: Fix panic in rolling window processing (#5066) (acf48ed)

Features

• cubesql: Datastudio - aggr by month and day support (#5025) (da3ed59)
• cubesql: Datastudio - between dates filter support (#5022) (20f7d64)
• cubesql: Datastudio - Min/Max datetime aggregation support (#5021) (7cf1f75)
• cubesql: Support DEALLOCATE in pg-wire (06b6476)
• drivers: Bootstraps CrateDB driver (#4929) (db87b8f)
• schema-compiler: aggregated sub query group by clause (#5078) (473398d)
• sqlite-driver: Bump sqlite3 to ^5.0.11 (8a16cc7)

0.30.29 (2022-07-01)

Bug Fixes

• cubesql: Can't find rewrite due to timeout reached for bigger ORDER BY queries (b765838)

Features

• cubesql: Initial support for DBeaver (#4831) (0a63152)
• cubesql: Send parameters at once (initial handshake) for pg-wire (#4812) (645253f)
• cubesql: Support Date type in pg-wire (Date32, Date64) (d0d08cf)
• pg-srv: Introduce ToProtocolValue trait (encoding) (#4818) (4e35aee)

0.30.4 (2022-05-20)

Bug Fixes

• cubesql: Skip returning of schema for special queries in pg-wire (479ec78)
• cubesql: Wrong format in RowDescription, support i16/i32/f32 (0c52cd6)
• cubestore: Prevent deleting a schema that contains tables (2824fb2)
• playground: refresh stale tokens (#4551) (80ce87d)
• playground: Remove all time time dimension without granularity (#4564) (054f488)
• refresh worker force queue reconcile logic (#4529) (144e97d)

Features

• Download streaming select * from table originalSql pre-aggregations directly (#4537) (a62d81a)
• cubesql: Allow ::oid casting (bb31838)
• cubesql: Initial support for type receivers (452f504)
• cubesql: Support ||, correct schema/catalog/ordinal_position (6d6cbf5)
• cubesql: Support DISCARD [ALL | PLANS | SEQUENCES | TEMPORARY |… (#4560) (390c764)
• cubesql: Support IS TRUE|FALSE (4d227b1)
• cubestore: Adds minio s3 region env to cubestore cloud storage (#4539) Thanks @olejeglejeg! (739d79c)