Timestamp-Methods fail

[kajen3]

What happened?

While creating a minimum working example to experiment with timestamp methods (code below), calling any of the timestamp-methods raises an error.

import ibis
import datetime as dt

con = ibis.duckdb.connect()
table = ibis.memtable({"date": [dt.datetime(2021, 12, 31), dt.datetime(2022, 1, 1)]}, name="t")
table.date.year()

What version of ibis are you using?

8.0.0

What backend(s) are you using, if any?

DuckDB (0.10.1)

Relevant log output

duckdb.duckdb.BinderException: Binder Error: No function matches the given name and argument types 'date_part(STRING_LITERAL, VARCHAR)'. You might need to add explicit type casts.
        Candidate functions:
        date_part(VARCHAR, DATE) -> BIGINT
        date_part(VARCHAR, TIMESTAMP) -> BIGINT
        date_part(VARCHAR, TIME) -> BIGINT
        date_part(VARCHAR, INTERVAL) -> BIGINT
        date_part(VARCHAR, TIME WITH TIME ZONE) -> BIGINT
        date_part(VARCHAR[], DATE) -> STRUCT()
        date_part(VARCHAR[], TIMESTAMP) -> STRUCT()
        date_part(VARCHAR[], TIME) -> STRUCT()
        date_part(VARCHAR[], INTERVAL) -> STRUCT()
        date_part(VARCHAR[], TIME WITH TIME ZONE) -> STRUCT()
        date_part(VARCHAR, TIMESTAMP WITH TIME ZONE) -> BIGINT
        date_part(VARCHAR[], TIMESTAMP WITH TIME ZONE) -> STRUCT()

Code of Conduct

• I agree to follow this project's Code of Conduct

[cpcloud]

Can you try with a prerelease?

pip install 'ibis-framework[duckdb]' --pre --upgrade

This appears to be fixed on main:

In [1]: import ibis
   ...: import datetime as dt
   ...:
   ...: con = ibis.duckdb.connect()
   ...: table = ibis.memtable(
   ...:     {"date": [dt.datetime(2021, 12, 31), dt.datetime(2022, 1, 1)]}, name="t"
   ...: )
   ...: table.date.year()
Out[1]:
r0 := InMemoryTable
  data:
    PandasDataFrameProxy:
              date
      0 2021-12-31
      1 2022-01-01

ExtractYear(date): ExtractYear(r0.date)

In [2]: ibis.options.interactive = True

In [3]: table.date.year()
Out[3]:
┏━━━━━━━━━━━━━━━━━━━┓
┃ ExtractYear(date) ┃
┡━━━━━━━━━━━━━━━━━━━┩
│ int32             │
├───────────────────┤
│              2021 │
│              2022 │
└───────────────────┘

[kajen3]

Solved the issue. Thanks.