【详述】3.3.11正常执行的sql，在3.4.4上explain报错Unknown error.
explain with brand_df as (
select
CASE
WHEN 'A' IN (
brand_code,
brand_id,
brand_nm,
brand_geo_type
) THEN 'S'
ELSE 'SSS'
end as brand_type
from
(
select
brand_code,
brand_id,
brand_nm,
brand_geo_type
from
table
)
)
select
*
from
brand_df
limit
10
报错：
java.lang.NullPointerException: null
at com.starrocks.sql.optimizer.rewrite.scalar.NormalizePredicateRule.getOptimizedCompoundTree(NormalizePredicateRule.java:189) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.rewrite.scalar.NormalizePredicateRule.visitCompoundPredicate(NormalizePredicateRule.java:139) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.rewrite.scalar.NormalizePredicateRule.visitInPredicate(NormalizePredicateRule.java:260) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.rewrite.scalar.NormalizePredicateRule.visitInPredicate(NormalizePredicateRule.java:49) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.operator.scalar.InPredicateOperator.accept(InPredicateOperator.java:89) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.rewrite.scalar.BaseScalarOperatorRewriteRule.apply(BaseScalarOperatorRewriteRule.java:41) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.rewrite.ScalarOperatorRewriter.applyRuleBottomUp(ScalarOperatorRewriter.java:139) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.rewrite.ScalarOperatorRewriter.applyRuleBottomUp(ScalarOperatorRewriter.java:136) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.rewrite.ScalarOperatorRewriter.rewriteByRule(ScalarOperatorRewriter.java:120) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.rewrite.ScalarOperatorRewriter.rewrite(ScalarOperatorRewriter.java:102) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.SqlToScalarOperatorTranslator.translate(SqlToScalarOperatorTranslator.java:193) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.SqlToScalarOperatorTranslator.translate(SqlToScalarOperatorTranslator.java:164) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.QueryTransformer.project(QueryTransformer.java:269) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.QueryTransformer.project(QueryTransformer.java:259) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.QueryTransformer.plan(QueryTransformer.java:142) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.RelationTransformer.visitSelect(RelationTransformer.java:281) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.RelationTransformer.visitSelect(RelationTransformer.java:160) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.SelectRelation.accept(SelectRelation.java:232) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:84) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:80) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.RelationTransformer.transform(RelationTransformer.java:229) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.RelationTransformer.visitCTE(RelationTransformer.java:790) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.RelationTransformer.visitCTE(RelationTransformer.java:160) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.CTERelation.accept(CTERelation.java:79) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:84) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:80) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.QueryTransformer.planFrom(QueryTransformer.java:172) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.QueryTransformer.plan(QueryTransformer.java:86) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.RelationTransformer.visitSelect(RelationTransformer.java:281) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.RelationTransformer.visitSelect(RelationTransformer.java:160) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.SelectRelation.accept(SelectRelation.java:232) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:84) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:80) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.RelationTransformer.transform(RelationTransformer.java:216) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.transformer.RelationTransformer.transformWithSelectLimit(RelationTransformer.java:197) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.createQueryPlanWithReTry(StatementPlanner.java:339) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:144) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:101) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:606) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:431) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:631) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:969) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:71) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:829) ~[?:?]
感谢大佬