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

Make "LATERAL VIEW inline(expression) mytable" tolerant to nulls

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.14.0
    • Fix Version/s: 1.2.0
    • Component/s: Query Processor, UDF
    • Labels:
      None
    • Environment:

      hdp 2.2
      Windows server 2012 R2 64-bit

      Description

      I have tweets stored with avro on hdfs with the default twitter status (tweet) schema.
      There's an object called "entities" that contains arrays of structs.
      When I run

      SELECT mytable.*
      FROM tweets
      LATERAL VIEW INLINE(entities.media) mytable

      I get the exception attached as partial_log.log, however, if I add
      WHERE entities.media IS NOT NULL
      it runs perfectly.

        Attachments

        1. parial_log.log
          54 kB
          Moustafa Aboul Atta
        2. HIVE-9507.3.patch.txt
          2 kB
          Navis
        3. HIVE-9507.2.patch.txt
          1.0 kB
          Navis
        4. HIVE-9507.1.patch.txt
          1.0 kB
          Navis

          Activity

            People

            • Assignee:
              navis Navis
              Reporter:
              totto90 Moustafa Aboul Atta
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: