GitHub user dosubot[bot] added a comment to the discussion: Superset is not able to recognise the NULL datatype of any column
<!-- Answer --> The difference is likely due to stricter validation or changes in dependencies (like SQLAlchemy or database drivers) in Superset 3.0.0, not a change in Superset's core logic. In both 2.1.0 and 3.0.0, if a column's type is NULL or missing, Superset marks it as UNKNOWN and can't use it for time-based features. However, 3.0.0 introduced stricter handling for time columns, so ambiguous or missing types that may have been tolerated in 2.1.0 now cause issues in 3.0.0. There were also regressions in 3.0.0 related to time column recognition that were fixed in 3.0.2 ([discussion](https://github.com/apache/superset/issues/22774), [related thread](https://github.com/apache/superset/discussions/35135)). To avoid this, make sure your timestamp column in Hydrolix has an explicit datetime type. If you can't change the schema, you would need to patch the connector or engine spec to handle NULL types, but Superset itself can't recognize NULL as a valid temporal type in any recent version ([code reference](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/connectors/sqla/utils.py)). <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/29f07be7-a475-48e7-822b-084828182d96?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/29f07be7-a475-48e7-822b-084828182d96?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/29f07be7-a475-48e7-822b-084828182d96?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/29f07be7-a475-48e7-822b-084828182d96?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/29f07be7-a475-48e7-822b-084828182d96?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/29f07be7-a475-48e7-822b-084828182d96?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/29f07be7-a475-48e7-822b-084828182d96?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)& nbsp;[](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/35188) GitHub link: https://github.com/apache/superset/discussions/35188#discussioncomment-14443904 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
