dosubot[bot] commented on issue #34718: URL: https://github.com/apache/superset/issues/34718#issuecomment-3191397133
<!-- Answer --> You're right—the histogram field in Superset only accepts columns with the # icon, which means they're recognized as numeric by Superset's backend. If your DuckDB FLOAT/DOUBLE column shows a ? icon, it's because Superset 5.0.0 uses strict regex matching on the column type string: only types starting with float, double, decimal, or numeric are recognized as numeric. DuckDB often returns type strings like DOUBLE PRECISION or DECIMAL(18,4), which don't match these patterns, so Superset doesn't recognize them as numeric and you can't drag them into numeric-only fields like histograms—even if the actual data is floating point. This is a backend limitation, not a UI bug ([details](https://github.com/apache/superset/discussions/34717#discussioncomment-14115291)). There's no SQL-level workaround in 5.0.0 if casting doesn't change the type string to something Superset recognizes. The only reliable fix is to patch Superset's DuckDB engine spec to recognize the actual type string DuckDB produces, or upgrade to a newer Superset version where this logic is improved ([reference](https://github.com/apache/superset/pull/34213)). <!-- 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/3d6a5d22-1ede-4579-99bf-7c43586b5b66?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/3d6a5d22-1ede-4579-99bf-7c43586b5b66?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/3d6a5d22-1ede-4579-99bf-7c43586b5b66?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/3d6a5d22-1ede-4579-99bf-7c43586b5b66?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/3d6a5d22-1ede-4579-99bf-7c43586b5b66?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/3d6a5d22-1ede-4579-99bf-7c43586b5b66?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/3d6a5d22-1ede-4579-99bf-7c43586b5b66?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu b) [](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/issues/34718) -- 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]
