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

Regression: Union of null with non-null

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.0
    • Fix Version/s: 2.2.0
    • Component/s: Query Planning
    • Labels:
      None
    • Release Note:
      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

            People

            • Assignee:
              gopalv Gopal Vijayaraghavan
              Reporter:
              gopalv Gopal Vijayaraghavan
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: