[KYLIN-1989] Sum(expression): result not consistent with hive

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v1.5.2
• Fix Version/s: v2.4.0
• Assignee: Hongbin Ma
• Reporter: Le Van Ha
• Created: 31/Aug/16 08:42
• Updated: 14/Sep/18 02:53
• Resolved: 14/Sep/18 02:52

Description

When do the following query,

SELECT channel.name, sum(case when product.product_vendor <> '' then fact_product.quantity else 0 end)
FROM fact_product_sales as fact_product
join dim_product as product on fact_product.product_id = product.id
join dim_channel as channel on fact_product.channel_id = channel.id
GROUP BY channel.name
-------------------------------------------------------------------
The result by kylin:
Buy Button 0
Online Store 0
-------------------------------------------------------------------
The result by hive is shown in figure.

Why is that?

Issue Links

• duplicates: KYLIN-1573 aggregator expression like sum(a+b) is not working