[
https://issues.apache.org/jira/browse/HIVE-9507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14313737#comment-14313737
]
Lefty Leverenz commented on HIVE-9507:
--------------------------------------
No doc needed, right?
> Make "LATERAL VIEW inline(expression) mytable" tolerant to nulls
> ----------------------------------------------------------------
>
> Key: HIVE-9507
> URL: https://issues.apache.org/jira/browse/HIVE-9507
> Project: Hive
> Issue Type: Bug
> Components: Query Processor, UDF
> Affects Versions: 0.14.0
> Environment: hdp 2.2
> Windows server 2012 R2 64-bit
> Reporter: Moustafa Aboul Atta
> Assignee: Navis
> Priority: Minor
> Fix For: 1.2.0
>
> Attachments: HIVE-9507.1.patch.txt, HIVE-9507.2.patch.txt,
> HIVE-9507.3.patch.txt, parial_log.log
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
