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

JDBC: Strip the default union prefix for un-enclosed UNION queries

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.1.1, 4.0.0
    • 4.0.0-alpha-1
    • Logical Optimizer
    • None

    Description

      beeline> select 1  union all select 2;
      
      +----------+
      | _u1._c0  |
      +----------+
      | 2        |
      | 1        |
      +----------+
      

      The _u1 is superfluous and harmful to result schema parsing.

      Attachments

        1. HIVE-21768.1.patch
          0.9 kB
          Gopal Vijayaraghavan
        2. HIVE-21768.2.patch
          2 kB
          Gopal Vijayaraghavan
        3. HIVE-21768.3.patch
          3 kB
          Gopal Vijayaraghavan
        4. HIVE-21768.4.patch
          8 kB
          Gopal Vijayaraghavan

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            gopalv Gopal Vijayaraghavan Assign to me
            gopalv Gopal Vijayaraghavan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment