1 Release published by 1 person

• 9.2.0

  published Jul 22, 2024

41 Pull requests merged by 8 people

• fix(druid): get basic timestamp functionality working

  #9692 merged Jul 25, 2024

• depr(snowflake): deprecate from_snowpark method

  #9680 merged Jul 25, 2024

• chore(deps): update clickhouse/clickhouse-server docker tag to v24.6.3.64

  #9690 merged Jul 24, 2024

• chore(deps): remove packaging package where it is not used

  #9683 merged Jul 24, 2024

• docs(presentations): update overview slides

  #9685 merged Jul 24, 2024

• refactor(internals): remove unnecessary dynamism in drop method

  #9682 merged Jul 24, 2024

• fix(case): fix dshape, error on noncomparable and empty cases

  #9559 merged Jul 24, 2024

• chore(deps): update clickhouse/clickhouse-server docker tag to v24.6.3.56

  #9678 merged Jul 24, 2024

• docs: replace all double graves with single graves

  #9679 merged Jul 24, 2024

• fix(drop): ignore order for DropColumns equality

  #9677 merged Jul 24, 2024

• ci(mssql): adjust to new location of sqlcmd

  #9681 merged Jul 24, 2024

• perf(selectors): speed up the c selector by caching the column existence check

  #9676 merged Jul 23, 2024

• refactor(polars): delete some dead versioning code

  #9675 merged Jul 23, 2024

• fix(polars): fix polars std/var to properly handle sample/population

  #9674 merged Jul 23, 2024

• refactor(polars): remove casting where possible; handle conversion on output

  #9673 merged Jul 23, 2024

• perf(duckdb): remove numeric literal casts when compiling sql

  #9664 merged Jul 23, 2024

• refactor(polars): remove extra backwards compatibility code no longer in use after 1.0 upgrade

  #9670 merged Jul 23, 2024

• fix(polars): remove bogus minus-one-week truncation

  #9672 merged Jul 23, 2024

• test(schema): ensure that we attempt to call __arrow_c_schema__

  #9671 merged Jul 23, 2024

• chore(deps): update clickhouse/clickhouse-server docker tag to v24.6.3.47

  #9668 merged Jul 23, 2024

• feat(backends): support creation from a DB-API con

  #9603 merged Jul 22, 2024

• feat(pyarrow): support __arrow_c_schema__ on ibis.Schema objects

  #9665 merged Jul 22, 2024

• feat(api): accept more input types in ibis.range

  #9659 merged Jul 22, 2024

• fix(mssql): avoid calling .commit() unless a DDL operation is being performed

  #9658 merged Jul 22, 2024

• feat(api): support selectors in window function order_by and group_by

  #9649 merged Jul 22, 2024

• feat(api): support deferred or string column names in cov/corr methods

  #9657 merged Jul 22, 2024

• fix(mssql): always pass port to pyodbc in host string

  #9656 merged Jul 22, 2024

• chore(deps): remove unused pydeps dependency

  #9651 merged Jul 22, 2024

• perf(relocate): avoid redundant selector position computation

  #9644 merged Jul 22, 2024

• perf(rename): avoid unnecessary rewrites and dereferencing in rename

  #9641 merged Jul 22, 2024

• chore(deps): bump nixpkgs and relock project deps

  #9636 merged Jul 22, 2024

• fix(api): add support for using deferreds in the argmin/argmax key argument

  #9652 merged Jul 22, 2024

• perf(drop): use _fast_bind to speed up drop even more

  #9646 merged Jul 22, 2024

• docs(how-to): add a guide on streaming operations

  #9642 merged Jul 22, 2024

• chore(conda): relax python pinned version in the flink yaml file

  #9640 merged Jul 20, 2024

• refactor(viz): avoid repeatedly rendering redundant schemas in graphviz output

  #9518 merged Jul 19, 2024

• fix(pyspark): set catalog and database with USE instead of pyspark api

  #9620 merged Jul 19, 2024

• ci(exasol): add the astronauts dataset for testing

  #9635 merged Jul 18, 2024

• feat(postgres): support basic jsonb type and existing operations

  #9630 merged Jul 18, 2024

• test(snowflake): add tests for inserting from a list of dictionaries

  #9632 merged Jul 18, 2024

• test(ci): ensure that we do not skip all of test_client.py if polars is not installed

  #9617 merged Jul 18, 2024

8 Pull requests opened by 4 people

• feat(api): add programmatic `epoch` API for computing unix epoch in seconds, milliseconds, and microseconds

  #9634 opened Jul 18, 2024

• refactor(joins): require explicit abstract table as RHS of joins

  #9661 opened Jul 22, 2024

• feat(pyarrow): support arrow PyCapsule interface in more places

  #9663 opened Jul 22, 2024

• refactor(duckdb): deprecate `read_in_memory`

  #9666 opened Jul 22, 2024

• perf(expressions): speed up `.describe()` and `.info()` expression construction

  #9684 opened Jul 24, 2024

• test: remove `broken` marker, better define `notimpl` and `notyet`

  #9688 opened Jul 24, 2024

• feat(duckdb): support arbitrary url prefixes

  #9691 opened Jul 24, 2024

• test(benchmark): remove unnecessary `date` call in benchmark

  #9693 opened Jul 25, 2024

24 Issues closed by 5 people

• feat: DDL Materialized Views

  #5964 closed Jul 24, 2024

• feat: list materialized views

  #5962 closed Jul 24, 2024

• feat: expression level definition of CSV and Parquet data sources

  #6898 closed Jul 24, 2024

• bug: RecursionError raised when attempting to create a duckdb table from a pandas-backed exp

  #4677 closed Jul 24, 2024

• docs: extending/adding backends

  #2307 closed Jul 24, 2024

• Add Option to Pass psychopg2 Connection

  #9051 closed Jul 23, 2024

• bug(UDF): python UDFs that return dicts/ir.Structs get field order messed up

  #9613 closed Jul 23, 2024

• bug(geospatial): casting of literals preventing filter push down to parquet reader

  #9662 closed Jul 23, 2024

• bug: timestamp truncation shifts time with polars backend

  #9618 closed Jul 23, 2024

• [meta] Ibis expression API stability

  #8996 closed Jul 23, 2024

• bug: StructFilter::ToExpression not yet supported

  #9667 closed Jul 22, 2024

• feat: Reuse the existing DB connection while creating backend

  #8877 closed Jul 22, 2024

• feat: Support registering `parquet` files for MSSQL backends

  #9648 closed Jul 22, 2024

• feat: add from_repr functionality

  #9623 closed Jul 22, 2024

• bug(timestamps): `ibis.range` doesn't accept `ibis.timestamp` objects (ibis expressions)

  #9557 closed Jul 22, 2024

• test(mssql): flaky test around dataframe interchange protocol

  #9654 closed Jul 22, 2024

• feat(api): support selectors in window function `group_by` and `order_by` arguments

  #9637 closed Jul 22, 2024

• ibis.mssql.connect login timeout expired

  #9619 closed Jul 22, 2024

• perf: Ibis slows down considerably for wider tables

  #9111 closed Jul 22, 2024

• bug(duckdb): corr seems broken on default backend

  #9645 closed Jul 20, 2024

• [meta] Ibis backend public API stability

  #8994 closed Jul 19, 2024

• bug: unable to set database for table registered in databricks unity catalog using shared cluster

  #9604 closed Jul 19, 2024

• bug: Postgres: UndefinedFunction extracting elements from JSONB

  #9626 closed Jul 18, 2024

• bug: Unsupported cast from None to pyarrow

  #9543 closed Jul 18, 2024

10 Issues opened by 8 people

• bug: read_parquet mangles huggingface prefix

  #9689 opened Jul 24, 2024

• bug: histogram(nbins=N) off by one error

  #9687 opened Jul 24, 2024

• bug(postgres): cross-schema column mixing

  #9686 opened Jul 24, 2024

• bug: Errors with NULL columns

  #9669 opened Jul 23, 2024

• feat: Implement Arrow PyCapsule Interface for data import, schema

  #9660 opened Jul 22, 2024

• feat: ability to specify how floats are displayed in interactive repr

  #9655 opened Jul 22, 2024

• ci(perf): track benchmarks in ci

  #9653 opened Jul 22, 2024

• feat: Support directly writing from BigQuery to parquet (dir) (or other formats e.g. CSV) via `EXPORT`

  #9643 opened Jul 20, 2024

• feat: optimize table info() and describe() for large column tables efficiently

  #9639 opened Jul 19, 2024

• meta: Ibis expression and backend stability

  #9638 opened Jul 19, 2024

25 Unresolved conversations

Sometimes conversations happen on old items that aren’t yet closed. Here is a list of all the Issues and Pull Requests with unresolved conversations.

• feat(api): move from .case() to .cases()

  #9096 commented on Jul 24, 2024 • 6 new comments

• test: add test for impure function correlation behavior

  #9014 commented on Jul 24, 2024 • 2 new comments

• docs(blog): kaggle competition using IbisML

  #9505 commented on Jul 24, 2024 • 1 new comment

• refactor(dependencies): optional numpy and pandas

  #9564 commented on Jul 23, 2024 • 0 new comments

• feat(parse_sql): add support for sge.Cast and sge.DataType

  #9510 commented on Jul 23, 2024 • 0 new comments

• feat: support empty arrays, improve ibis.array() API

  #9473 commented on Jul 23, 2024 • 0 new comments

• refactor(all): unify method signaturse across backends

  #9383 commented on Jul 19, 2024 • 0 new comments

• test: fix ArrayValue.remove() handling of NULLs

  #9089 commented on Jul 24, 2024 • 0 new comments

• feat(api): `day_of_week.iso_index()` method

  #9003 commented on Jul 19, 2024 • 0 new comments

• feat(flink): support semi/anti window join

  #8745 commented on Jul 23, 2024 • 0 new comments

• feat: Support for Microsoft Fabric Warehouse

  #9494 commented on Jul 25, 2024 • 0 new comments

• feat: make `Table.cache()` a no-op for tables that are already concrete in a backend

  #6195 commented on Jul 24, 2024 • 0 new comments

• feat: Array.sum(), .min(), .max(), mean(), etc.

  #7073 commented on Jul 24, 2024 • 0 new comments

• bug: no handling for interval columns in pyarrow interactive repr

  #8138 commented on Jul 24, 2024 • 0 new comments

• feat: Ability to Distinguish between Table and Views

  #8382 commented on Jul 23, 2024 • 0 new comments

• Cross-backend table creation and insertion

  #8115 commented on Jul 23, 2024 • 0 new comments

• docs(blog/how to): Ibis + duckdb spatial + geoparquet + lonboard

  #9598 commented on Jul 22, 2024 • 0 new comments

• feat: Consistent tablenotfound exception across backends

  #9468 commented on Jul 22, 2024 • 0 new comments

• feat: `to_duckdb`

  #9629 commented on Jul 22, 2024 • 0 new comments

• bug: cannot directly execute an expression connected to DuckDB table on PySpark backend

  #9602 commented on Jul 22, 2024 • 0 new comments

• feat: remove `IntegerValue.label()`

  #9612 commented on Jul 22, 2024 • 0 new comments

• feat: add support for polars, arrow RBR as RHS of a join

  #9571 commented on Jul 22, 2024 • 0 new comments

• docs: Unclear how to materialize a table or list materialized tables

  #7742 commented on Jul 22, 2024 • 0 new comments

• feat: Support `type` arg to `ibis.array` and `ibis.map`

  #8289 commented on Jul 19, 2024 • 0 new comments

• bug: mssql does not implement `_from_url()`

  #9415 commented on Jul 18, 2024 • 0 new comments