hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-9507) Make "LATERAL VIEW inline(expression) mytable" tolerant to nulls
Date Tue, 10 Feb 2015 01:40:34 GMT

    [ https://issues.apache.org/jira/browse/HIVE-9507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14313345#comment-14313345
] 

Hive QA commented on HIVE-9507:
-------------------------------



{color:green}Overall{color}: +1 all checks pass

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12697431/HIVE-9507.3.patch.txt

{color:green}SUCCESS:{color} +1 7540 tests passed

Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2728/testReport
Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2728/console
Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2728/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12697431 - PreCommit-HIVE-TRUNK-Build

> 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
>         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)

Mime
View raw message