duckdb/duckdb-python

View on GitHub

The DuckDB Python package

Stars: 186
Forks: 113
Open beginner issues: 3
Indexed issues: 44
Avg merge: 20h 58m
Merged PRs (30d): 11

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

Beginner friendly Everything

Open All

44 open issues indexed

Type stubs omit the `connection` keyword on module-level `read_json` and `write_csv` Open

Difficulty 2/5 1-3 hours Newbie friendliness 90/100

duckdb/duckdb-python#627 · Opened Sep 21, 2026
duckdb.sql() on a piped CSV silently returns wrong results; con.execute() on the same input is correct Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 48/100

duckdb/duckdb-python#622 · Opened Sep 16, 2026
Streaming result buffers the entire result in memory when rows contain large VARCHAR values Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 52/100

duckdb/duckdb-python#617 · 2 comments · Opened Sep 11, 2026
Arrow scan: a NULL row passes a pushed-down `<=` filter against a NaN constant Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 68/100

duckdb/duckdb-python#615 · Opened Sep 9, 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

Difficulty 5/5 Over a week Newbie friendliness 25/100

duckdb/duckdb-python#613 · 1 comment · Opened Sep 6, 2026
`DuckDBPyRelation.query()`: reusing a virtual table name silently changes the result of an existing relation Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 45/100

duckdb/duckdb-python#604 · 1 reaction · Opened Aug 25, 2026
Translate unsupported fsspec modification times into a typed DuckDB error Open

Difficulty 4/5 3-5 days Newbie friendliness 68/100

duckdb/duckdb-python#584 · 2 comments · Opened Aug 13, 2026
Failure to collect operations that join two lazily retrieved Polars lazyframes Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 68/100

duckdb/duckdb-python#583 · Opened Aug 12, 2026
`read_json` accepts a list of paths at runtime but the type stub only allows a single path. Open

needs triage

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

duckdb/duckdb-python#576 · 3 comments · Opened Jul 31, 2026
`TIMESTAMPTZ` → Python conversion (`fetchone`/`.df()`/`.arrow()`) returns wrong DST offset for dates from 2038 onward (pytz Year 2038 bug) Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 52/100

duckdb/duckdb-python#579 · 1 comment · Opened Jul 28, 2026
UHUGEINT values>= 2^127 return negative w/ to_arrow_table Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 55/100

duckdb/duckdb-python#568 · Opened Jul 27, 2026
Decimal with a positive exponent is silently stored as its mantissa (Decimal('1E+2') → 1) Open

Difficulty 3/5 1-2 days Newbie friendliness 74/100

duckdb/duckdb-python#566 · 1 comment · Opened Jul 25, 2026
surprising `fetchall` return value on some queries, since 1.5.2 Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 55/100

duckdb/duckdb-python#535 · Opened Jul 4, 2026
Possible reference leak of the argument tuple in `FunctionCall()` Open

needs triage

Difficulty 2/5 1-3 hours Newbie friendliness 76/100

duckdb/duckdb-python#534 · Opened Jul 4, 2026
Crash when terminating process if Py_Finalize isn't called Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 45/100

duckdb/duckdb-python#531 · 1 comment · Opened Jul 3, 2026
Lifecycle problem with UDF functions Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 48/100

duckdb/duckdb-python#530 · Opened Jul 3, 2026
Arrow w/ arrow_output_version produces errors with VARINT, GEOMETRY and ENUMs Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 48/100

duckdb/duckdb-python#517 · Opened Jun 29, 2026
Surface engine WARNING-level log messages in the Python client (parity with the CLI) Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

duckdb/duckdb-python#480 · Opened Jun 5, 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

Difficulty 3/5 1-2 days Newbie friendliness 55/100

duckdb/duckdb-python#477 · Opened Jun 1, 2026
Pushdown Filter Type BLOOM_FILTER is not currently supported in PyArrow Scans Open

needs more info

Difficulty 4/5 3-5 days Newbie friendliness 35/100

duckdb/duckdb-python#463 · 3 comments · Opened May 18, 2026
read_csv() is not understanding some timestamp formats Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 68/100

duckdb/duckdb-python#442 · 2 comments · Opened May 4, 2026
Crashes while handling non-select result set (DataFrame) Open

needs triage

Difficulty 5/5 Over a week Newbie friendliness 35/100

duckdb/duckdb-python#428 · 1 reaction · Opened Apr 15, 2026
Columns names outputs are inconsistents and case sensitive Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 55/100

duckdb/duckdb-python#418 · Opened Apr 7, 2026
Illegal instruction when using duckdb in docker sandboxes Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 45/100

duckdb/duckdb-python#410 · Opened Mar 30, 2026
duckdb Python Extension Analysis Report Open

needs triage

Difficulty 5/5 Over a week Newbie friendliness 35/100

duckdb/duckdb-python#408 · Opened Mar 29, 2026
values() creates one row of arrays instead of multiple rows Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 55/100

duckdb/duckdb-python#407 · Opened Mar 28, 2026
Missing ROW_GROUPS_PER_FILE argument in write_parquet function Open

needs triage

Difficulty 2/5 1-3 hours Newbie friendliness 68/100

duckdb/duckdb-python#386 · Opened Mar 18, 2026
fetch_record_batch is 2x/3x slower than raw pyArrow Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 35/100

duckdb/duckdb-python#359 · 1 comment · Opened Mar 2, 2026
Using `sql_tokenize()` table function for tokenization. Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 45/100

duckdb/duckdb-python#338 · 1 reaction · Opened Feb 23, 2026
Python SDK read_parquet union_by_name fail after version 1.2.2 Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 45/100

duckdb/duckdb-python#259 · 5 comments · Opened Jan 8, 2026
Deadlock on insert with cursors and fetchmany Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 38/100

duckdb/duckdb-python#182 · 4 comments · Opened Nov 16, 2025
DuckDB Spark API is incompatible with the PySpark API's `spark.createDataFrame(list of dict)` Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 45/100

duckdb/duckdb-python#183 · Opened Nov 15, 2025
.cursor() loses schema information Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 45/100

duckdb/duckdb-python#162 · Opened Nov 5, 2025
overwrite parameter to relation.write_csv and write_parquet seems to do nothing Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 50/100

duckdb/duckdb-python#156 · Opened Nov 1, 2025
`select()` ignores `distinct` Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 45/100

duckdb/duckdb-python#154 · 1 comment · Opened Oct 31, 2025
ComputeError: caught exception during execution of a Python source Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 38/100

duckdb/duckdb-python#128 · 2 comments · Opened Oct 17, 2025
the dataframe of "sql(query).fetch_df()" lost index Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 35/100

duckdb/duckdb-python#125 · 1 comment · Opened Oct 15, 2025
Table with name does not exist Open

needs triage

Difficulty 3/5 1-2 days Newbie friendliness 38/100

duckdb/duckdb-python#114 · 4 comments · Opened Oct 9, 2025
duckdb sniff_csv fails with > 10240 lines Open

needs triage

Difficulty 4/5 3-5 days Newbie friendliness 38/100

duckdb/duckdb-python#113 · 6 comments · Opened Oct 9, 2025
Error when trying to parse multiple rows via Relational API `values` Open

reproduced

Difficulty 3/5 1-2 days Newbie friendliness 45/100

duckdb/duckdb-python#79 · 3 comments · Opened Sep 22, 2025
Incorrect results / failure from query requiring multiple scans of arrow stream Open

reproduced

Difficulty 4/5 3-5 days Newbie friendliness 45/100

duckdb/duckdb-python#70 · 10 comments · 1 reaction · Opened Sep 18, 2025
Excel Extension fails to load all data even though stop_at_empty = false Open

reproduced

Difficulty 3/5 1-2 days Newbie friendliness 42/100

duckdb/duckdb-python#64 · 3 comments · Opened Sep 17, 2025
ColumnExpression doesn't escape column name containing `.` Open

Difficulty 3/5 1-2 days Newbie friendliness 52/100

duckdb/duckdb-python#46 · 2 comments · Opened Sep 12, 2025
DuckDB spawns worker threads on module import rather than connection creation Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

duckdb/duckdb-python#612 · 2 comments · Opened Aug 19, 2025

duckdb/duckdb-python

Get new issues in your inbox