dosubot[bot] commented on issue #41280: URL: https://github.com/apache/superset/issues/41280#issuecomment-4770954325
<!-- Answer --> Hey @rusackas — this looks like a **sqlglot version mismatch**. The `YearOfWeek` expression class was introduced in sqlglot v28 [[1]](https://github.com/apache/superset/pull/37841), but the current Superset codebase pins sqlglot to `>=26.1.3, <27` [[2]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/pyproject.toml#L97), resolving to `sqlglot==26.28.1` [[3]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/requirements/base.txt#L378). So official Superset shouldn't reference `YearOfWeek` at all with its pinned dependency. A couple of things stand out: 1. **There is no official Superset 6.1.0 release** — the latest tag is 5.0.0. So @mueller-ma may be using an unofficial Docker image or third-party packaging that bundles a mismatched sqlglot version. 2. **The likely scenario**: the environment has Superset code that was built against sqlglot v28+ (which has `exp.YearOfWeek`), but the installed sqlglot is actually v26 which lacks it — or vice versa: sqlglot v28+ is installed but old Superset code tries to import something that doesn't exist yet. Either way, the dependency versions are out of sync. **Workaround for the reporter**: exec into the container and run `pip show sqlglot` to check the version. If it's v28+, downgrading to match the constraint (`pip install "sqlglot>=26.1.3,<27"`) should resolve it. But the real fix is using an official Superset Docker image at a valid release tag (e.g., `apache/superset:4.1.1` or `apache/superset:5.0.0`). <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).* --- Share context across your team and agents. Try [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-tagline&utm_term=apache%2Fsuperset). [](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-feedback&utm_term=apache%2Fsuperset&message_id=922777de-065f-4726-873e-0eb59f97569e) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-learn-repo&utm_term=apache%2Fsuperset) [](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-add-team&utm_term=apache%2Fsuperset) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
