Affects Version/s: 2.1.1
Fix Version/s: None
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.
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