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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • None
    • 0.3.0, 0.4.0
    • None
    • None
    • Reviewed
    • 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

      Attachments

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

        Activity

          People

            namit Namit Jain
            namit Namit Jain
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: