[ https://issues.apache.org/jira/browse/HIVE-12559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15034783#comment-15034783 ]
Laljo John Pullokkaran commented on HIVE-12559: ----------------------------------------------- https://docs.oracle.com/cd/E19957-01/806-3568/ncg_math.html > Vectorization on MR produces different results > ---------------------------------------------- > > Key: HIVE-12559 > URL: https://issues.apache.org/jira/browse/HIVE-12559 > Project: Hive > Issue Type: Bug > Reporter: Laljo John Pullokkaran > Assignee: Matt McCline > > Vectorization on MR produces different results for semantically equivalent > queries. > SET hive.vectorized.execution.enabled=true; > SET hive.auto.convert.join=true; > SET hive.auto.convert.join.noconditionaltask=true; > SET hive.auto.convert.join.noconditionaltask.size=1000000000; > SET hive.cbo.enable=false; > select sum(v1.cdouble) from alltypesorc v3 join alltypesorc v1 on > v1.csmallint=v3.csmallint join alltypesorc v2 on v1.ctinyint=v2.ctinyint; > -- Produces 6.065190932488167E11 > select sum(v1.cdouble) from alltypesorc v1 join alltypesorc v2 on > v1.ctinyint=v2.ctinyint join alltypesorc v3 on v1.csmallint=v3.csmallint; > -- Produces 6.065190932486892E11 -- This message was sent by Atlassian JIRA (v6.3.4#6332)