Tag: apache-calcite

Column is not being grouped exception in Scatterplot

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 be…

Apache Calcite throws error when using COALESCE with untyped nulls only

apache-calcite coalesce sql

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. …