hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt McCline (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11371) Null pointer exception for nested table query when using ORC versus text
Date Tue, 04 Aug 2015 05:07:04 GMT

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

Matt McCline commented on HIVE-11371:
-------------------------------------

Interesting, it does not repro on master.  There was a late bug fix for outer join -- perhaps
that fixed this problem and you don't have the fix.

[~the6campbells] What is the last commit date and id on the build you are using?  Thanks.

> Null pointer exception for nested table query when using ORC versus text
> ------------------------------------------------------------------------
>
>                 Key: HIVE-11371
>                 URL: https://issues.apache.org/jira/browse/HIVE-11371
>             Project: Hive
>          Issue Type: Bug
>          Components: Vectorization
>    Affects Versions: 1.2.0
>            Reporter: N Campbell
>            Assignee: Matt McCline
>         Attachments: TJOIN1, TJOIN2, TJOIN3, TJOIN4
>
>
> Following query will fail if the file format is ORC 
> select tj1rnum, tj2rnum, tjoin3.rnum as rnumt3 from   (select tjoin1.rnum tj1rnum, tjoin2.rnum
tj2rnum, tjoin2.c1 tj2c1  from tjoin1 left outer join tjoin2 on tjoin1.c1 = tjoin2.c1 ) tj
 left outer join tjoin3 on tj2c1 = tjoin3.c1 
> aused by: java.lang.NullPointerException
> 	at org.apache.hadoop.hive.ql.exec.vector.VectorCopyRow$LongCopyRow.copy(VectorCopyRow.java:60)
> 	at org.apache.hadoop.hive.ql.exec.vector.VectorCopyRow.copyByReference(VectorCopyRow.java:260)
> 	at org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinGenerateResultOperator.generateHashMapResultMultiValue(VectorMapJoinGenerateResultOperator.java:238)
> 	at org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinOuterGenerateResultOperator.finishOuter(VectorMapJoinOuterGenerateResultOperator.java:495)
> 	at org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinOuterLongOperator.process(VectorMapJoinOuterLongOperator.java:430)
> 	... 22 more
> ]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 killedTasks:0, Vertex
vertex_1437788144883_0004_2_02 [Map 1] killed/failed due to:null]DAG did not succeed due to
VERTEX_FAILURE. failedVertices:1 killedVertices:0
> SQLState:  08S01
> ErrorCode: 2
> getDatabaseProductName	Apache Hive
> getDatabaseProductVersion	1.2.1.2.3.0.0-2557
> getDriverName	Hive JDBC
> getDriverVersion	1.2.1.2.3.0.0-2557
> getDriverMajorVersion	1
> getDriverMinorVersion	2
> create table  if not exists TJOIN1 (RNUM int , C1 int, C2 int)
> -- ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' 
>  STORED AS orc 					;
> create table  if not exists TJOIN2 (RNUM int , C1 int, C2 char(2))
> -- ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' 
>  STORED AS orc ;
> create table  if not exists TJOIN3 (RNUM int , C1 int, C2 char(2))
> -- ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' 
>  STORED AS orc ;
> create table  if not exists TJOIN4 (RNUM int , C1 int, C2 char(2))
> -- ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' 
>  STORED AS orc ;



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

Mime
View raw message