[ https://issues.apache.org/jira/browse/HIVE-10379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14505303#comment-14505303 ]
ErwanMAS commented on HIVE-10379: --------------------------------- I have downloaded the hortonworks sandbox 2.2.4 . It's fixed . It's a duplicate of HIVE-8888 . > Wrong result when executing with tez > ------------------------------------- > > Key: HIVE-10379 > URL: https://issues.apache.org/jira/browse/HIVE-10379 > Project: Hive > Issue Type: Bug > Components: Tez > Affects Versions: 0.13.0, 0.14.0 > Environment: Hortonworks sandbox 2.1.1 & 2.2.0 > Reporter: ErwanMAS > Assignee: Gunther Hagleitner > Fix For: 1.0.0 > > Attachments: HIVE-10379.1.patch > > > I do a left join with a lateral view outer , too many row are generated with > tez . > in map reduce , i have 125 rows , in tez 132 ..... > Example : > {noformat} > drop table foo ; > create table foo ( dummyfoo int ) ; > insert into table foo select count(*) from foo ; > select count(*) as cnt from ( > select a.val,p.code from > ( select cast((((one*5)+two)*5+three) as int) as val > from foo > lateral view outer > explode(split("0,1,2,3,4",",")) tbl_1 as one > lateral view outer > explode(split("0,1,2,3,4",",")) tbl_2 as two > lateral view outer > explode(split("0,1,2,3,4",",")) tbl_3 as three ) as a > left join > ( select dummyfoo as code from foo ) p on p.code=a.val > ) w ; > set hive.execution.engine=tez; > set hive.vectorized.execution.enabled=false; > select count(*) as cnt from ( > select a.val,p.code from > ( select cast((((one*5)+two)*5+three) as int) as val > from foo > lateral view outer > explode(split("0,1,2,3,4",",")) tbl_1 as one > lateral view outer > explode(split("0,1,2,3,4",",")) tbl_2 as two > lateral view outer > explode(split("0,1,2,3,4",",")) tbl_3 as three ) as a > left join > ( select dummyfoo as code from foo ) p on p.code=a.val > ) w ; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)