You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Dean Ye (JIRA)" <ji...@apache.org> on 2017/09/22 03:57:00 UTC
[jira] [Created] (HIVE-17577) UNION without DISTINCT doesn't work
Dean Ye created HIVE-17577:
------------------------------
Summary: UNION without DISTINCT doesn't work
Key: HIVE-17577
URL: https://issues.apache.org/jira/browse/HIVE-17577
Project: Hive
Issue Type: Bug
Components: CLI
Affects Versions: 2.1.1
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.
Reporter: Dean Ye
Priority: Minor
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
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)