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

allow union set operation without ALL keyword (align to ISO-SQL 2011 specification)

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 0.8.0
    • 1.2.0
    • SQL
    • None

    Description

      Allow a union operation to be specified as <qb1> union <qb2> in addition to th <qb1> union all <qb2>

      Common requirement of queries to project two sets where it is not always the case you want distinct rows in the set. Failing to do so obviously will result in the current exception:
      mismatched input 'select' expecting ALL near 'union' in query operator

      Attachments

        Issue Links

          Activity

            People

              pxiong Pengcheng Xiong
              the6campbells N Campbell
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: