[ https://issues.apache.org/jira/browse/KYLIN-1989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liyang updated KYLIN-1989: -------------------------- Summary: Sum(expression): result not consistent with hive (was: Sum issue: result not consistent with hive) > Sum(expression): 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 > Assignee: hongbin ma > Attachments: hive_result.png, kylin_result.png > > > 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)