duckdb/duckdb-python

View on GitHub

The DuckDB Python package

Stars: 187
Forks: 112
Open beginner issues: 0
Indexed issues: 42
Avg merge: 13h 29m
Merged PRs (30d): 17

Dominant language: Python
License: MIT
Last GitHub push: Sep 12, 2026
Latest indexed: Sep 15, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed

Open All

42 open issues indexed

DuckDB spawns worker threads on module import rather than connection creation Open

duckdb/duckdb-python#612 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
ColumnExpression doesn't escape column name containing `.` Open

duckdb/duckdb-python#46 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Excel Extension fails to load all data even though stop_at_empty = false Open

reproduced

duckdb/duckdb-python#64 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Incorrect results / failure from query requiring multiple scans of arrow stream Open

reproduced

duckdb/duckdb-python#70 · 10 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Error when trying to parse multiple rows via Relational API `values` Open

reproduced

duckdb/duckdb-python#79 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
duckdb sniff_csv fails with > 10240 lines Open

needs triage

duckdb/duckdb-python#113 · 6 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Table with name does not exist Open

needs triage

duckdb/duckdb-python#114 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
the dataframe of "sql(query).fetch_df()" lost index Open

needs triage

duckdb/duckdb-python#125 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
ComputeError: caught exception during execution of a Python source Open

needs triage

duckdb/duckdb-python#128 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`select()` ignores `distinct` Open

needs triage

duckdb/duckdb-python#154 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
overwrite parameter to relation.write_csv and write_parquet seems to do nothing Open

needs triage

duckdb/duckdb-python#156 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
.cursor() loses schema information Open

needs triage

duckdb/duckdb-python#162 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
DuckDB Spark API is incompatible with the PySpark API's `spark.createDataFrame(list of dict)` Open

needs triage

duckdb/duckdb-python#183 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Deadlock on insert with cursors and fetchmany Open

needs triage

duckdb/duckdb-python#182 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Python SDK read_parquet union_by_name fail after version 1.2.2 Open

needs triage

duckdb/duckdb-python#259 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Using `sql_tokenize()` table function for tokenization. Open

needs triage

duckdb/duckdb-python#338 · 0 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
fetch_record_batch is 2x/3x slower than raw pyArrow Open

needs triage

duckdb/duckdb-python#359 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Missing ROW_GROUPS_PER_FILE argument in write_parquet function Open

needs triage

duckdb/duckdb-python#386 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
values() creates one row of arrays instead of multiple rows Open

needs triage

duckdb/duckdb-python#407 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
duckdb Python Extension Analysis Report Open

needs triage

duckdb/duckdb-python#408 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Illegal instruction when using duckdb in docker sandboxes Open

needs triage

duckdb/duckdb-python#410 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Columns names outputs are inconsistents and case sensitive Open

needs triage

duckdb/duckdb-python#418 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Crashes while handling non-select result set (DataFrame) Open

needs triage

duckdb/duckdb-python#428 · 0 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
read_csv() is not understanding some timestamp formats Open

needs triage

duckdb/duckdb-python#442 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Pushdown Filter Type BLOOM_FILTER is not currently supported in PyArrow Scans Open

needs more info

duckdb/duckdb-python#463 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
read_csv from filehandle, when turned into a view, stops working with `No files found that match the pattern "DUCKDB_INTERNAL_OBJECTSTORE://...` Open

needs triage

duckdb/duckdb-python#477 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Surface engine WARNING-level log messages in the Python client (parity with the CLI) Open

duckdb/duckdb-python#480 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Arrow w/ arrow_output_version produces errors with VARINT, GEOMETRY and ENUMs Open

needs triage

duckdb/duckdb-python#517 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Lifecycle problem with UDF functions Open

needs triage

duckdb/duckdb-python#530 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Crash when terminating process if Py_Finalize isn't called Open

needs triage

duckdb/duckdb-python#531 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Possible reference leak of the argument tuple in `FunctionCall()` Open

needs triage

duckdb/duckdb-python#534 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
surprising `fetchall` return value on some queries, since 1.5.2 Open

needs triage

duckdb/duckdb-python#535 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Decimal with a positive exponent is silently stored as its mantissa (Decimal('1E+2') → 1) Open

duckdb/duckdb-python#566 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
UHUGEINT values>= 2^127 return negative w/ to_arrow_table Open

needs triage

duckdb/duckdb-python#568 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`TIMESTAMPTZ` → Python conversion (`fetchone`/`.df()`/`.arrow()`) returns wrong DST offset for dates from 2038 onward (pytz Year 2038 bug) Open

needs triage

duckdb/duckdb-python#579 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`read_json` accepts a list of paths at runtime but the type stub only allows a single path. Open

needs triage

duckdb/duckdb-python#576 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Failure to collect operations that join two lazily retrieved Polars lazyframes Open

needs triage

duckdb/duckdb-python#583 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Translate unsupported fsspec modification times into a typed DuckDB error Open

duckdb/duckdb-python#584 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`DuckDBPyRelation.query()`: reusing a virtual table name silently changes the result of an existing relation Open

needs triage

duckdb/duckdb-python#604 · 0 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Access violation (0xC0000005) in _duckdb.cp313-win_amd64.pyd during concurrent read-only queries; same defect on 1.4.4 and 1.5.5, two WER buckets; asking for symbolication of three offsets Open

duckdb/duckdb-python#613 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Arrow scan: a NULL row passes a pushed-down `<=` filter against a NaN constant Open

needs triage

duckdb/duckdb-python#615 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Streaming result buffers the entire result in memory when rows contain large VARCHAR values Open

needs triage

duckdb/duckdb-python#617 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026

duckdb/duckdb-python

Get new issues in your inbox