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

[ASF GitHub Bot (Jira)]

    [ 
https://issues.apache.org/jira/browse/KYLIN-5380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17652422#comment-17652422
 ] 

ASF GitHub Bot commented on KYLIN-5380:
---------------------------------------

hit-lacus merged PR #2057:
URL: https://github.com/apache/kylin/pull/2057




> 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
>            Assignee: leejaywei
>            Priority: Major
>             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)