hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vihang Karajgaonkar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17577) UNION without DISTINCT doesn't work
Date Fri, 22 Sep 2017 16:03:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-17577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16176628#comment-16176628
] 

Vihang Karajgaonkar commented on HIVE-17577:
--------------------------------------------

[~janulatha]

> 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)

Mime
View raw message