[HIVE-17577] UNION without DISTINCT doesn't work

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.1.1
• Component/s: CLI

Environment

Hive 2.1.1
Compiled by jcamachorodriguez on Tue Nov 29 19:46:12 GMT 2016
From source with checksum 569ad6d6e5b71df3cb04303183948d90

Test tables in both TEXTFILE and ORC format.

• Assignee: Unassigned
• Reporter: Dean Ye
• Created: 22/Sep/17 03:56
• Updated: 24/Sep/17 02:27

Description

We just upgrade Hive from 1.2.1 to 2.1.1, But the UNION command worked before just return
missing EOF at 'select' near 'union'. It works when I use UNION DISDINCT but doesn't without DISTINCT keyword.

below are copied from command line.

hive (dev)> select id from deantest union select id from dean_test;
FAILED: ParseException line 1:34 missing EOF at 'select' near 'union'

hive (dev)> select id from deantest union distinct select id from dean_test;
WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
Query ID = yeruidian_20170922112411_4a370da1-efb3-4464-a2f1-0e84e06ef5b6