This message was deleted.

What error are you getting in the ingestion?

"taskId": "a42c79ce-48c7-4940-a311-cc8aae2fb34d", "state": "FAILED", "error": { "error": "Plan validation failed", "errorMessage": "org.apache.druid.java.util.common.ISE: Encountered null type for column[dist_total_revenue]", "errorClass": "org.apache.calcite.tools.ValidationException", "host": null } }

can you paste the ingestion query here?

Sounds like you have some null inputs. Maybe you need something like NVL or ifnull, CASE, etc to replace any nulls with 0.

Hi ,when i ingested the data type as "float" instead of "floatSum" it worked.

interesting, gtk, thank you for the update