hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dean Ye (JIRA)" <>
Subject [jira] [Created] (HIVE-17577) UNION without DISTINCT doesn't work
Date Fri, 22 Sep 2017 03:57:00 GMT
Dean Ye created HIVE-17577:

             Summary: UNION without DISTINCT doesn't work
                 Key: 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

View raw message