[HIVE-11744] Correct table alias in auto_join17.q.out and etc

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 04/Sep/15 22:29
• Updated: 27/Sep/15 22:24
• Resolved: 27/Sep/15 22:24

Description

auto_join17.q include a self-join

explain
FROM src src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest1 SELECT src1.*, src2.*

in the output, we have both of the join branch to be

TableScan
            alias: src1

it is better if we have src1 and src2.

Issue Links

• is related to: HIVE-11614 CBO: Calcite Operator To Hive Operator (Calcite Return Path): ctas after order by has problem