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-8870) errors when selecting a struct field within an array from ORC based tables
Date Wed, 03 Dec 2014 01:55:13 GMT

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

Hive QA commented on HIVE-8870:
-------------------------------



{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/12684745/HIVE-8870.3.patch

{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 6695 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_vector_decimal_aggregate
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_optimize_nullscan
{noformat}

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

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: 2 tests failed
{noformat}

This message is automatically generated.

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

> errors when selecting a struct field within an array from ORC based tables
> --------------------------------------------------------------------------
>
>                 Key: HIVE-8870
>                 URL: https://issues.apache.org/jira/browse/HIVE-8870
>             Project: Hive
>          Issue Type: Bug
>          Components: File Formats, Query Processor
>    Affects Versions: 0.13.0, 0.14.0
>         Environment: HDP 2.1 / HDP 2.2 (YARN, but no Tez)
>            Reporter: Michael Haeusler
>            Assignee: Sergio Peña
>         Attachments: HIVE-8870.3.patch
>
>
> When using ORC as storage for a table, we get errors on selecting a struct field within
an array. These errors do not appear with default format.
> {code:sql}
> CREATE  TABLE `foobar_orc`(
>   `uid` bigint,
>   `elements` array<struct<elementid:bigint,foo:struct<bar:string>>>)
> STORED AS ORC;
> {code}
> When selecting from this _empty_ table, we get a direct NPE within the Hive CLI:
> {code:sql}
> SELECT
>   elements.elementId
> FROM
>   foobar_orc;
> -- FAILED: RuntimeException java.lang.NullPointerException
> {code}
> A more real-world query produces a RuntimeException / NullPointerException in the mapper:
> {code:sql}
> SELECT
>   uid,
>   element.elementId
> FROM
>   foobar_orc
> LATERAL VIEW
>   EXPLODE(elements) e AS element;
> Error: java.lang.RuntimeException: Error in configuring object
> 	at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:109)
> [...]
> Caused by: java.lang.NullPointerException
> 	at org.apache.hadoop.hive.ql.exec.ExprNodeFieldEvaluator.initialize(ExprNodeFieldEvaluator.java:61)
> [...]
> FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
> {code}
> Both queries run fine on a non-orc table:
> {code:sql}
> CREATE  TABLE `foobar`(
>   `uid` bigint,
>   `elements` array<struct<elementid:bigint,foo:struct<bar:string>>>);
 
> SELECT
>   elements.elementId
> FROM
>   foobar;
> -- OK
> -- Time taken: 0.225 seconds
> SELECT
>   uid,
>   element.elementId
> FROM
>   foobar
> LATERAL VIEW
>   EXPLODE(elements) e AS element;
> -- Total MapReduce CPU Time Spent: 1 seconds 920 msec
> -- OK
> -- Time taken: 25.905 seconds
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message