Releases 9.3.0
9.3.0 (2024-08-07)Features
api: support ignore_null in collect (71271dd )api: support ignore_null in first/last (8d4f97f )api: support order_by in order-sensitive aggregates (collect/group_concat/first/last) (#9729 ) (a18cb5d )api: support quarterly truncation (#9715 ) (75b31c2 ), closes #9714 array: implement min, max, any, all, sum, mean (#9704 ) (793efbc )bigquery: support timestamp bucket (fd61f2c )datafusion: pivot_longer (2330b0c )datafusion: enable array flatten, group concat, and timestamp now (4d110a0 )datafusion: struct literals (a63cee9 )datafusion: unnest (a706f54 )duckdb: add support for passing a subset of column types to read_csv (#9776 ) (c1dcf67 )duckdb: support arbitrary url prefixes (#9691 ) (11af489 )mssql: support case-sensitive collations (#9700 ) (9382a0e )oracle: support group_concat operator (47d97ea )pyspark: add support for pyarrow and python UDFs (#9753 ) (02a1d48 )snowflake: add userinfo URL parsing (524a2fa )ux: allow window functions in predicates and compile to QUALIFY where possible (#9787 ) (0370bcb )
Bug Fixes
algolia: add parent class docstring to algolia index (#9739 ) (3bc9799 )bigquery: repr geospatial values in interactive mode (#9712 ) (bd8c93f )case: fix dshape, error on noncomparable and empty cases (#9559 ) (ff2d019 )compiler-internals: define unsupported operations after simple operations (#9755 ) (d9b6264 )deps: update dependency atpublic to v5 (#9697 ) (a4f3940 )deps: update dependency sqlglot to >=23.4,<25.10 (#9774 ) (7144257 )deps: update dependency sqlglot to >=23.4,<25.8 (#9696 ) (d4a2ea2 )deps: update dependency sqlglot to >=23.4,<25.9 (#9719 ) (b1d8b2e )drop: ignore order for DropColumns equality (#9677 ) (ae1e112 )druid: get basic timestamp functionality working (#9692 ) (6cd3eee )duckdb: avoid literals casts that might defeat optimization (e4ff1bd )duckdb: ensure that array remove doesn't remove NULLs (f0c3be4 )duckdb: use register directly instead of calling read_in_memory (597817f )internals: ensure that CTEs are emitted in topological order (#9726 ) (acd7d82 )polars: fix polars std/var to properly handle sample/population (f83d84f )polars: remove bogus minus-one-week truncation (ac519b2 )postgres: handle enums by delegating to the parent class (#9769 ) (3f01075 ), closes #9295 snowflake: bring back where filter support in group_concat; fix array_agg ordering (#9758 ) (6e7e4de )sql: only return tables in current_database (#9748 ) (c7f5717 )types: fix histogram bin allocation (#9711 ) (6634864 ), closes #9687
Documentation
algolia: add custom attributes to backend and core methods (#9730 ) (d9473cf )browser-repl: fix jupyterlite build (#9762 ) (f403aa1 )fix spelling in pivot_longer explanation (#9780 ) (3201d8b )
fix typo in drop method docstring (#9727 ) (4cf0014 )
presentations: update overview slides (#9685 ) (d3a2c0c )replace all double graves with single graves (#9679 ) (dd26d60 )
Refactors
dependencies: pandas and numpy are now optional for non-backend installs (#9564 ) (cff210a )duckdb: use replace to generate less sql (#9713 ) (f89aa32 )internals: remove unnecessary dynamism in drop method (#9682 ) (5ac84c5 )pandas: remove unreachable code in pandas backend (#9786 ) (dc6bfe2 )polars: delete some dead versioning code (b23c5a3 )polars: remove casting where possible; handle conversion on output (#9673 ) (8717629 )polars: remove extra backwards compatibility code no longer in use after 1.0 upgrade (feb12f4 )sql: make compilers usable with a base install (#9766 ) (84a786d )table_loc: return consistent object from catalog.db parsing (#9743 ) (1ae2a37 )
Performance
schema: speed up failure case of duplicate keys when constructing schemas (#9698 ) (870ac73 )selectors: speed up the c selector by caching the column existence check (fdaeb5c )
Deprecations
You can’t perform that action at this time.
