[ https://issues.apache.org/jira/browse/HIVE-9507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14311859#comment-14311859 ]
Hive QA commented on HIVE-9507: ------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12697377/HIVE-9507.2.patch.txt {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 7526 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udf_inline {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2714/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2714/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2714/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12697377 - 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, > 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)