【StarRocks版本】例如:2.5.4
报错sql
select date_time, count(distinct test_array)
from (select [“1”] as test_array, ‘2021-01-01’ as date_time) tt
group by date_time
报错信息
2023-05-18 14:34:32,875 WARN (starrocks-mysql-nio-pool-465|54591) [StmtExecutor.execute():538] execute Exception, sql select date_time,count(distinct test_array) from (select [“1”] as test_array , ‘2021-01-01’ as date_time ) tt group by date_time
java.lang.NullPointerException: null
at com.starrocks.sql.optimizer.operator.scalar.ScalarOperatorUtil.buildMultiCountDistinct(ScalarOperatorUtil.java:38) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.rule.transformation.GroupByCountDistinctDataSkewEliminateRule.transform(GroupByCountDistinctDataSkewEliminateRule.java:148) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.task.ApplyRuleTask.execute(ApplyRuleTask.java:70) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.task.SeriallyTaskScheduler.executeTasks(SeriallyTaskScheduler.java:56) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.Optimizer.memoOptimize(Optimizer.java:434) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.Optimizer.optimizeByCost(Optimizer.java:151) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.Optimizer.optimize(Optimizer.java:93) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.createQueryPlan(StatementPlanner.java:95) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:66) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:37) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:381) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:323) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:440) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:698) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_252]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_252]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_252]