[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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0-beta
• Fix Version/s: 5.0-beta
• Assignee: zhong.zhu
• Reporter: zhong.zhu
• Created: 11/Dec/23 07:10
• Updated: 29/Mar/24 10:41
• Resolved: 29/Mar/24 10:41

Description

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

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