Hive
  1. Hive
  2. HIVE-384

problem in union if the first subquery is a map-only job

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.3.0, 0.4.0
    • Component/s: None
    • Labels:
      None
    • Hadoop Flags:
      Reviewed
    • Release Note:
      HIVE-384. Fixing UNION ALL when the first job is a map-only job. (Namit Jain via zshao)

      Description

      Union needs special handling.

      explain
      select unionsrc.key, count(1) FROM (select s2.key as key, s2.value as value from src1 s2
      UNION ALL
      select 'tst1' as key, cast(count(1) as string) as value from src s1)
      unionsrc group by unionsrc.key;

      results in a null pointer exception

      1. hive.384.6.patch
        72 kB
        Namit Jain
      2. hive.384.5.patch
        67 kB
        Namit Jain
      3. hive.384.4.patch
        74 kB
        Namit Jain
      4. hive.384.3.patch
        74 kB
        Namit Jain
      5. hive.384.2.patch
        1 kB
        Namit Jain
      6. hive.384.1.patch
        70 kB
        Namit Jain

        Activity

        Namit Jain created issue -
        Namit Jain made changes -
        Field Original Value New Value
        Attachment hive.384.1.patch [ 12404579 ]
        Namit Jain made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Namit Jain made changes -
        Status Patch Available [ 10002 ] Open [ 1 ]
        Namit Jain made changes -
        Attachment hive.384.2.patch [ 12404610 ]
        Namit Jain made changes -
        Attachment hive.384.3.patch [ 12404617 ]
        Namit Jain made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Namit Jain made changes -
        Comment [ fixed another minor bug in name of the job which was making my debugging more difficult ]
        Namit Jain made changes -
        Status Patch Available [ 10002 ] Open [ 1 ]
        Namit Jain made changes -
        Attachment hive.384.4.patch [ 12404619 ]
        Namit Jain made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Namit Jain made changes -
        Priority Major [ 3 ] Blocker [ 1 ]
        Namit Jain made changes -
        Status Patch Available [ 10002 ] Open [ 1 ]
        Namit Jain made changes -
        Attachment hive.384.5.patch [ 12404775 ]
        Namit Jain made changes -
        Attachment hive.384.6.patch [ 12404790 ]
        Namit Jain made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Zheng Shao made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Hadoop Flags [Reviewed]
        Release Note HIVE-384. Fixing UNION ALL when the first job is a map-only job. (Namit Jain via zshao)
        Fix Version/s 0.3.1 [ 12313845 ]
        Fix Version/s 0.4.0 [ 12313714 ]
        Resolution Fixed [ 1 ]
        Johan Oskarsson made changes -
        Fix Version/s 0.3.0 [ 12313637 ]
        Fix Version/s 0.3.1 [ 12313845 ]
        Carl Steinbach made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Namit Jain
            Reporter:
            Namit Jain
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development