GitHub user dosubot[bot] added a comment to the discussion: How to casting float to double in Superset 5.0.0?
<!-- Answer --> Superset only lets you use columns for histogram charts if they’re classified as “numeric” (GenericDataType.NUMERIC) by its backend. This classification depends on the exact type string DuckDB returns for your column. Superset uses regex patterns to match type strings that start with float, double, decimal, or numeric—if your column’s type string doesn’t match exactly (for example, if DuckDB returns something like DOUBLE PRECISION or a nonstandard label), Superset won’t recognize it as numeric, and the column will show up as “number” (non-numeric) in the chart menu, making it unavailable for the histogram field. This is all determined by backend logic and not something you can change from the UI or by casting in SQL Lab alone. To work around this, you’d need to either ensure DuckDB emits a standard type string (like DOUBLE or FLOAT) or patch Superset’s DuckDB engine spec to recognize the actual type string DuckDB produces for your column. There’s no separate “number” type in Superset’s backend—if a column isn’t recognized as numeric, it’s just not eligible for numeric-only chart fields like histograms. [Reference: Superset type mapping logic](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/6389648e-54ce-42a6-93c3-5fc6a2ea88bc?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/6389648e-54ce-42a6-93c3-5fc6a2ea88bc?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/6389648e-54ce-42a6-93c3-5fc6a2ea88bc?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/6389648e-54ce-42a6-93c3-5fc6a2ea88bc?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/6389648e-54ce-42a6-93c3-5fc6a2ea88bc?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/6389648e-54ce-42a6-93c3-5fc6a2ea88bc?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/6389648e-54ce-42a6-93c3-5fc6a2ea88bc?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-14115291 ---- 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]
