GitHub user dosubot[bot] added a comment to the discussion: How to casting float to double in Superset 5.0.0?
<!-- Answer --> Superset displays your DuckDB DOUBLE column as FLOAT in SQL Lab because both DOUBLE and FLOAT are mapped to the same internal SQLAlchemy type (`types.Float()`) by Superset’s type inference logic. This mapping is intentional and comes from regex patterns in the engine spec that treat any type string starting with "double" or "float" as a generic numeric type, but display it as FLOAT in the UI regardless of the original database type string. This does not affect the column’s usability as a numeric type for charts, as long as the type string matches the expected pattern for numeric recognition. [Source: Superset base engine spec code](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/db_engine_specs/base.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/98a69fcc-f9e8-49ec-8b42-62932f886cea?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/98a69fcc-f9e8-49ec-8b42-62932f886cea?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/98a69fcc-f9e8-49ec-8b42-62932f886cea?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/98a69fcc-f9e8-49ec-8b42-62932f886cea?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/98a69fcc-f9e8-49ec-8b42-62932f886cea?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/98a69fcc-f9e8-49ec-8b42-62932f886cea?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/98a69fcc-f9e8-49ec-8b42-62932f886cea?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/34717) GitHub link: https://github.com/apache/superset/discussions/34717#discussioncomment-14114743 ---- 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]
