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

NPE for query involving UNION ALL with nested JOIN and UNION ALL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 0.9.0
    • Fix Version/s: 0.11.0
    • Labels:
      None
    • Environment:

      Red Hat Linux VM with Hive 0.9 and Hadoop 2.0

    • Hadoop Flags:
      Reviewed

      Description

      UNION ALL query with JOIN in first part and another UNION ALL in second part gives NPE.

      JOIN

      UNION ALL

      UNION ALL

      Attachments:
      1. HiveCommands.txt : command script to setup schema for query under consideration.
      2. sourceData1.txt and sourceData2.txt : required for above command script.
      3. Query.txt : Exact query which produces NPE.

      NOTE: you will need to update path to sourceData1.txt and sourceData2.txt in the HiveCommands.txt to suit your environment.

      Attached files contain the schema and exact query which fails on Hive 0.9.
      It is worthwhile to note that the same query executes successfully on Hive 0.7.

        Attachments

        1. HiveCommands.txt
          0.9 kB
          Mihir Kulkarni
        2. sourceData1.txt
          0.0 kB
          Mihir Kulkarni
        3. sourceData2.txt
          0.0 kB
          Mihir Kulkarni
        4. Query.txt
          0.4 kB
          Mihir Kulkarni
        5. HIVE-4342.D10407.1.patch
          32 kB
          Phabricator

          Activity

            People

            • Assignee:
              navis Navis Ryu
              Reporter:
              mihirk Mihir Kulkarni
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: