Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
v1.5.2
-
None
-
None
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?
Attachments
Attachments
Issue Links
- duplicates
-
KYLIN-1573 aggregator expression like sum(a+b) is not working
- Closed