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

Regression: Union of null with non-null

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
    • 2.2.0
    • 2.2.0
    • Query Planning
    • None
    • Regression: Union of null with non-null (Gopal V, reviewed by Sergey Shelukhin)

    Description

      hive> select null as c1 union select 1 as c2;
    FAILED: SemanticException Schema of both sides of union should match: Column c1 is of type void on first table and type int on second table. Cannot tell the position of null AST.

      This looks related to HIVE-14251 which removed certain cases from the UNION type coercion operations.

      Attachments

        1. HIVE-16050.2.patch
          3 kB
          Gopal Vijayaraghavan
        2. HIVE-16050.1.patch
          2 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:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment