Le Van Ha created KYLIN-1989:
--------------------------------
Summary: Sum issue: result not consistent with hive
Key: KYLIN-1989
URL: https://issues.apache.org/jira/browse/KYLIN-1989
Project: Kylin
Issue Type: Bug
Affects Versions: v1.5.2
Reporter: Le Van Ha
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?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
