[jira] [Created] (KYLIN-5736) When query includes a large number of in conditional statements, the SQL recommendation reports an error

["zhong.zhu (Jira)" <ji...@apache.org>]

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)