SQL:
select “table”."c0" as "c0" from “table" as “table" where UPPER(“table”."c0") =
UPPER(‘xxx') group by “table”."c0" order by CASE WHEN “table”."c0" IS NULL THEN
0 ELSE 1 END, “table”."c0" ASC
stacktrace:
Caused by: java.lang.NullPointerException
at org.apache.kylin.cube.CubeSegment.dictKey(CubeSegment.java:297)
at
org.apache.kylin.cube.CubeSegment.getDictResPath(CubeSegment.java:289)
at org.apache.kylin.cube.CubeManager.getDictionary(CubeManager.java:207)
at org.apache.kylin.cube.CubeSegment.getDictionary(CubeSegment.java:315)
at
org.apache.kylin.cube.kv.CubeDimEncMap.getDictionary(CubeDimEncMap.java:87)
at
org.apache.kylin.dict.BuiltInFunctionTransformer.translateCompareTupleFilter(BuiltInFunctionTransformer.java:120)
at
org.apache.kylin.dict.BuiltInFunctionTransformer.transform(BuiltInFunctionTransformer.java:58)
at
org.apache.kylin.storage.gtrecord.CubeSegmentScanner.<init>(CubeSegmentScanner.java:67)
at
org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:136)
at
org.apache.kylin.query.enumerator.OLAPEnumerator.queryStorage(OLAPEnumerator.java:114)
at
org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:64)
at Baz$1$1.moveNext(Unknown Source)
at
org.apache.calcite.linq4j.EnumerableDefaults.distinct(EnumerableDefaults.java:449)
at
org.apache.calcite.linq4j.DefaultEnumerable.distinct(DefaultEnumerable.java:206)
at Baz.bind(Unknown Source)
at
org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(CalcitePrepare.java:327)
at
org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(CalciteConnectionImpl.java:282)
at
org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(CalciteMetaImpl.java:553)
at
org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(CalciteMetaImpl.java:544)
at
org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:187)
at
org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:65)
at
org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:44)
at
org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:605)
at
org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:599)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:613)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:139)
—
郑舒力
13311008875
