Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-17577

UNION without DISTINCT doesn't work

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.1.1
    • Fix Version/s: None
    • Component/s: CLI
    • Labels:
      None
    • 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.

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              langcaiye Dean Ye
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: