GitHub user dosubot[bot] added a comment to the discussion: How to casting float to double in Superset 5.0.0?
<!-- Answer --> Superset only recognizes DuckDB columns as "numeric" for histograms if the column's type string starts with `float`, `double`, `decimal`, or `numeric`—this is determined by strict regex matching in Superset's backend. If DuckDB returns a type string like `DOUBLE PRECISION` or `DECIMAL(18,4)`, Superset won't recognize it as numeric, even after casting, so the column stays unusable for histograms [[source]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/db_engine_specs/base.py). To troubleshoot: in SQL Lab, run `SELECT typeof(column_name) FROM table LIMIT 1` to see the exact type string DuckDB emits after casting. If it doesn't start with one of the recognized patterns, Superset won't accept it. You can try casting to a type that matches the pattern (e.g., `CAST(column_name AS DOUBLE) AS double_col`), but if DuckDB still returns a nonstandard type string, the only reliable fix is to patch Superset's DuckDB engine spec to add a regex for the actual DuckDB type string. Also, make sure to filter out nulls from your column before creating the histogram chart—Superset 5.0.0 enforces strict null handling for histograms [[source]](https://github.com/apache/superset/issues/33738#issuecomment-2961105288). Let me know the result of the `typeof` query if you want more targeted advice! <!-- 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/723d4449-7ab6-4463-b59f-d24df0c34b51?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/723d4449-7ab6-4463-b59f-d24df0c34b51?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/723d4449-7ab6-4463-b59f-d24df0c34b51?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/723d4449-7ab6-4463-b59f-d24df0c34b51?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/723d4449-7ab6-4463-b59f-d24df0c34b51?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/723d4449-7ab6-4463-b59f-d24df0c34b51?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/723d4449-7ab6-4463-b59f-d24df0c34b51?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-14114540 ---- 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]
