[jira] [Created] (KYLIN-5743) Set kylin.query.convert-sum-expression-enabled=true, fail to completely hit the aggregate index when the query contains sum (case when) expressions

[zhong.zhu (Jira)]

zhong.zhu created KYLIN-5743:
--------------------------------

             Summary: Set kylin.query.convert-sum-expression-enabled=true, fail 
to completely hit the aggregate index when the query contains sum (case when) 
expressions
                 Key: KYLIN-5743
                 URL: https://issues.apache.org/jira/browse/KYLIN-5743
             Project: Kylin
          Issue Type: Bug
    Affects Versions: 5.0-beta
            Reporter: zhong.zhu
            Assignee: zhong.zhu
             Fix For: 5.0.0


{code:sql}
select
  sum(
    case
      when LO_COMMITDATE = '20230501' then LO_DISCOUNT
    end
  )
from
  (
    select
      LO_COMMITDATE,
      LO_DISCOUNT,
      LINEORDER.LO_ORDERDATE
    from
      ssb.LINEORDER
  ) a
where
  LO_COMMITDATE = (
    select
      max(LO_COMMITDATE)
    from
      ssb.LINEORDER
  )
LIMIT
  500
{code}

Fix the sum case when in this scenario so that it hits aggregated indexes



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