[HIVE-2466] mapjoin_subquery dump small table (mapjoin table) to the same file

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.7.1
• Fix Version/s: 0.8.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Lijin Bin
• Reporter: Lijin Bin
• Created: 23/Sep/11 16:39
• Updated: 16/Dec/11 23:56
• Resolved: 08/Nov/11 05:53

Description

in mapjoin_subquery.q there is a query：
SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
FROM
(SELECT /*+ MAPJOIN */ 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
JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11);
when dump x and z to a local file,there all dump to the same file, so we lost the data of x