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

feat(sql): load parsed but unsupported types as unknown #9868

Merged

Conversation

gforsyth
Copy link
Member

@gforsyth gforsyth commented Aug 19, 2024

Description of changes

This is a loose follow-up to #9576.

In that PR, I added support for falling back to dt.unknown when sqlglot
failed to parse a type string. In that case, it was usually handling things
like user-defined types in Postgres.

This is a related change, where we mark a dtype as unknown if sqlglot does
parse it correctly, but we don't have support for the dtype. The user can't
operate on the column in question, but at least the table will load.

A representative issue is loading a table in Clickhouse that has a uint256 column

Issues closed

xref #9861

Closes #9869.

Copy link
Member

@cpcloud cpcloud left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Nice!

@cpcloud cpcloud added feature Features or general enhancements datatypes Issues relating to ibis's datatypes (under `ibis.expr.datatypes`) labels Aug 19, 2024
@cpcloud cpcloud merged commit a76acfc into ibis-project:main Aug 19, 2024
87 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
datatypes Issues relating to ibis's datatypes (under `ibis.expr.datatypes`) feature Features or general enhancements
Projects
None yet
Development

Successfully merging this pull request may close these issues.

bug(clickhouse): query clickhouse table with uint256 type columns
2 participants