hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-11371) Null pointer exception for nested table query when using ORC versus text
Date Thu, 02 Jun 2016 10:18:05 GMT

     [ https://issues.apache.org/jira/browse/HIVE-11371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jesus Camacho Rodriguez updated HIVE-11371:
-------------------------------------------
    Fix Version/s:     (was: 2.1.0)
                       (was: 1.3.0)

> 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
>             Fix For: 2.0.0
>
>         Attachments: HIVE-11371.01.patch, HIVE-11371.02.patch, HIVE-11371.03.patch, 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