Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

bug: ibis 10.3.0 fails to load with sqlglot==26.3.9 #10994

Closed
1 task done
amoeba opened this issue Mar 13, 2025 · 1 comment · Fixed by #10993
Closed
1 task done

bug: ibis 10.3.0 fails to load with sqlglot==26.3.9 #10994

amoeba opened this issue Mar 13, 2025 · 1 comment · Fixed by #10993
Labels
bug Incorrect behavior inside of ibis

Comments

@amoeba
Copy link
Contributor

amoeba commented Mar 13, 2025

What happened?

I had an existing virtual environment set up with Ibis 10.0.0 and, after upgrading to Ibis 10.3.0, I could no longer import ibis.

What version of ibis are you using?

10.0.0 at first, now 10.3.0

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

None

Relevant log output

.venv ❯ uv pip install "ibis-framework[duckdb]==10.0.0"
Resolved 20 packages in 354ms
Prepared 1 package in 649ms
Installed 20 packages in 181ms
 + atpublic==5.1
 + duckdb==1.2.1
 + ibis-framework==10.0.0
 + markdown-it-py==3.0.0
 + mdurl==0.1.2
 + numpy==2.2.3
 + packaging==24.2
 + pandas==2.2.3
 + parsy==2.1
 + pyarrow==19.0.1
 + pyarrow-hotfix==0.6
 + pygments==2.19.1
 + python-dateutil==2.9.0.post0
 + pytz==2025.1
 + rich==13.9.4
 + six==1.17.0
 + sqlglot==26.3.9
 + toolz==1.0.0
 + typing-extensions==4.12.2
 + tzdata==2025.1

~/tmp/ibis-103-sqlot-bug
.venv ❯ uv pip install "ibis-framework[duckdb]==10.3.0"
Resolved 20 packages in 56ms
Prepared 1 package in 344ms
Uninstalled 1 package in 232ms
Installed 1 package in 20ms
 - ibis-framework==10.0.0
 + ibis-framework==10.3.0

~/tmp/ibis-103-sqlot-bug
.venv ❯ python
Python 3.13.0 (main, Oct 16 2024, 08:05:40) [Clang 18.1.8 ] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import ibis
Traceback (most recent call last):
  File "<python-input-0>", line 1, in <module>
    import ibis
  File "/Users/bryce/tmp/ibis-103-sqlot-bug/.venv/lib/python3.13/site-packages/ibis/__init__.py", line 14, in <module>
    from ibis.expr import api
  File "/Users/bryce/tmp/ibis-103-sqlot-bug/.venv/lib/python3.13/site-packages/ibis/expr/api.py", line 28, in <module>
    from ibis.expr.sql import parse_sql, to_sql
  File "/Users/bryce/tmp/ibis-103-sqlot-bug/.venv/lib/python3.13/site-packages/ibis/expr/sql.py", line 18, in <module>
    from ibis.backends.sql.datatypes import SqlglotType
  File "/Users/bryce/tmp/ibis-103-sqlot-bug/.venv/lib/python3.13/site-packages/ibis/backends/sql/datatypes.py", line 22, in <module>
    typecode.BLOB: dt.Binary,
    ^^^^^^^^^^^^^
AttributeError: type object 'Type' has no attribute 'BLOB'

.venv ❯ uv pip install "sqlglot==26.10.0"
Resolved 1 package in 166ms
Prepared 1 package in 79ms
Uninstalled 1 package in 9ms
Installed 1 package in 2ms
 - sqlglot==26.3.9
 + sqlglot==26.10.0

~/tmp/ibis-103-sqlot-bug
.venv ❯ python
Python 3.13.0 (main, Oct 16 2024, 08:05:40) [Clang 18.1.8 ] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import ibis

Code of Conduct

  • I agree to follow this project's Code of Conduct
@amoeba
Copy link
Contributor Author

amoeba commented Mar 14, 2025

Thanks for the quick fix and release @cpcloud. I can confirm Ibis 10.3.1 now works alongside sqlglot==26.3.9 where 10.3.0 didn't.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Incorrect behavior inside of ibis
Projects
Status: done
1 participant