[ https://issues.apache.org/jira/browse/HIVE-10379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14500402#comment-14500402 ]
Sergey Shelukhin commented on HIVE-10379: ----------------------------------------- [~hagleitn] fyi > 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 > > 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)