[ https://issues.apache.org/jira/browse/HIVE-1997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1997: --------------------------------- Fix Version/s: (was: 0.7.0) > Map join followed by multi-table insert will generate duplicated result > ----------------------------------------------------------------------- > > Key: HIVE-1997 > URL: https://issues.apache.org/jira/browse/HIVE-1997 > Project: Hive > Issue Type: Bug > Components: Query Processor > Reporter: Ted Xu > > Map join followed by multi-table insert will generate duplicated result, if > the insert targets contain both direct insert (FileSinkOperator logic) and > group by/distribute by (ReduceSinkOperator logic). > The following query regenerate the case: > {code} > FROM > (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, > y.value as value2 > FROM src1 x JOIN src y ON (x.key = y.key)) subq > INSERT OVERWRITE TABLE destpart PARTITION (ds='2010-12-12') > SELECT key1, value1 > INSERT OVERWRITE TABLE destpart PARTITION (ds='2010-12-13') > SELECT key2, value2 > GROUP BY key2, value2; > {code} > In that query above, records of table destpart(ds='2010-12-12') is duplicated. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira