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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 0.14.0
    • 1.2.0
    • Query Processor, UDF
    • None
    • 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. HIVE-9507.1.patch.txt
          1.0 kB
          Navis Ryu
        2. parial_log.log
          54 kB
          Moustafa Aboul Atta
        3. HIVE-9507.2.patch.txt
          1.0 kB
          Navis Ryu
        4. HIVE-9507.3.patch.txt
          2 kB
          Navis Ryu

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: