You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by "leejaywei (Jira)" <ji...@apache.org> on 2022/12/20 02:32:00 UTC

[jira] [Created] (KYLIN-5380) Querying sql contain "null" or " <" or ">" or "0" at the end of where condition will case exception

leejaywei created KYLIN-5380:
--------------------------------

             Summary: Querying sql contain "null" or " <" or ">" or "0" at the end of where condition will case exception
                 Key: KYLIN-5380
                 URL: https://issues.apache.org/jira/browse/KYLIN-5380
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 5.0-alpha
            Reporter: leejaywei
             Fix For: 5.0-alpha


查询中过滤条件 ”null <> 0“ 不处于 where 语句结尾时, 发生异常的问题

问题:

”null <> 0“ 不处于 where 语句结尾时, 无法命中索引, 提示需要开启下压查询, 开启下压后可以查询成功

示例 sql :

select * from SSB_YUGAN.LINEORDER
where null <> 0 or LO_CUSTKEY != 0
LIMIT 500



--
This message was sent by Atlassian Jira
(v8.20.10#820010)