zhong.zhu created KYLIN-5736: -------------------------------- Summary: When query includes a large number of in conditional statements, the SQL recommendation reports an error Key: KYLIN-5736 URL: https://issues.apache.org/jira/browse/KYLIN-5736 Project: Kylin Issue Type: Bug Affects Versions: 5.0-beta Reporter: zhong.zhu Assignee: zhong.zhu Fix For: 5.0.0
A large number of in queries exist, and null pointer errors occur during recommendation. As a result, effective intelligent recommendation cannot be generated. The logs are as follows: {code:java} // code placeholder Root cause: nulljava.util.regex.Pattern.compile(Pattern.java:1685)java.util.regex.Pattern.<init>(Pattern.java:1351)java.util.regex.Pattern.compile(Pattern.java:1028)java.lang.String.replaceAll(String.java:2223)org.apache.calcite.sql.SqlDialect.quoteIdentifier(SqlDialect.java:242)org.apache.calcite.sql.pretty.SqlPrettyWriter.identifier(SqlPrettyWriter.java:909)org.apache.calcite.sql.SqlIdentifier.unparse(SqlIdentifier.java:298)org.apache.calcite.sql.SqlUtil.unparseInSyntax(SqlUtil.java:344)org.apache.calcite.sql.SqlSyntax$4.unparse(SqlSyntax.java:79)org.apache.calcite.sql.SqlOperator.unparse(SqlOperator.java:332)org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:321)org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:103)org.apache.calcite.sql.SqlUtil.unparseBinarySyntax(SqlUtil.java:323)org.apache.calcite.sql.SqlSyntax$3.unparse(SqlSyntax.java:65)org.apache.calcite.sql.SqlOperator.unparse(SqlOperator.java:332)org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:321)org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:103)org.apache.calcite.sql.SqlUtil.unparseBinarySyntax(SqlUtil.java:323)org.apache.calcite.sql.SqlSyntax$3.unparse(SqlSyntax.java:65)org.apache.calcite.sql.SqlOperator.unparse(SqlOperator.java:332)org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:321)org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:103)org.apache.calcite.sql.SqlUtil.unparseBinarySyntax(SqlUtil.java:323)org.apache.calcite.sql.SqlSyntax$3.unparse(SqlSyntax.java:65)org.apache.calcite.sql.SqlOperator.unparse(SqlOperator.java:332)org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:321)org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:103) {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)