(superset) 01/01: fix: Pin compatible DuckDB versions to resolve showtime examples loading

[el...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

elizabeth pushed a commit to branch fix-duckdb-version-compatibility
in repository https://gitbox.apache.org/repos/asf/superset.git

commit 1cf14f10815779b3f455f278a97dd58120047db6
Author: Elizabeth Thompson <es...@gmail.com>
AuthorDate: Thu Sep 25 18:00:36 2025 -0700

    fix: Pin compatible DuckDB versions to resolve showtime examples loading
    
    This fixes the 'unhashable type: _duckdb.typing.DuckDBPyType' error that
    prevents DuckDB connections from working in showtime ephemeral environments.
    
    Problem: The current DuckDB versions (duckdb==1.3.2, duckdb-engine==0.17.0)
    have type system compatibility issues with Superset's DuckDB integration.
    
    Solution: Pin to older, stable versions that are known to work:
    - duckdb==1.0.0 (stable core library)
    - duckdb-engine==0.11.2 (compatible SQLAlchemy driver)
    
    This enables showtime environments to successfully connect to DuckDB databases
    and load examples from the pre-built examples.duckdb file.
    
    🤖 Generated with [Claude Code](https://claude.ai/code)
    
    Co-Authored-By: Claude <no...@anthropic.com>
---
 pyproject.toml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/pyproject.toml b/pyproject.toml
index 4c6ecd7a52..b224978ab3 100644
--- a/pyproject.toml
+++ b/pyproject.toml
@@ -133,7 +133,7 @@ denodo = ["denodo-sqlalchemy~=1.0.6"]
 dremio = ["sqlalchemy-dremio>=1.2.1, <4"]
 drill = ["sqlalchemy-drill>=1.1.4, <2"]
 druid = ["pydruid>=0.6.5,<0.7"]
-duckdb = ["duckdb-engine>=0.17.0"]
+duckdb = ["duckdb==1.0.0", "duckdb-engine==0.11.2"]
 dynamodb = ["pydynamodb>=0.4.2"]
 solr = ["sqlalchemy-solr >= 0.2.0"]
 elasticsearch = ["elasticsearch-dbapi>=0.2.9, <0.3.0"]