I am trying to create a Scatter chart in OmniSci with a Y-Axis set to the following custom measure: but the chart fails to render and throws the following exception: What would be the best way to “group by” the footage_drilled field so that it complys with the Scatterplot requirements? Answer I believe the issue is you need to wrap
Tag: apache-calcite
Apache Calcite throws error when using COALESCE with untyped nulls only
When runnning SELECT COALESCE(NULL, NULL); on Apache Calcite I get an error which tells that ELSE clause or at least one THEN clause must be non-NULL This happens because COALESCE function is transformed to CASE expression and the latter is validated for whether at least one THEN or ELSE operand is not null. If all are NULL, then the error