[
https://issues.apache.org/jira/browse/HIVE-9739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
N Campbell updated HIVE-9739:
-----------------------------
Summary: Various queries fails with Tez/ORC file
org.apache.hadoop.hive.ql.exec.tez.TezTask (was: Quantified query fails with
Tez/ORC file org.apache.hadoop.hive.ql.exec.tez.TezTask)
> Various queries fails with Tez/ORC file
> org.apache.hadoop.hive.ql.exec.tez.TezTask
> ----------------------------------------------------------------------------------
>
> Key: HIVE-9739
> URL: https://issues.apache.org/jira/browse/HIVE-9739
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Reporter: N Campbell
>
> This fails when using Tez and ORC.
> It will run when text files are used or text/ORC and MapReduce and not Tez
> used.
> Is this another example of a type issue per
> https://issues.apache.org/jira/browse/HIVE-9735
> select rnum, c1, c2 from tset1 as t1 where exists ( select c1 from tset2
> where c1 = t1.c1 )
> This will run in both Tez and MapReduce using a text file
> select rnum, c1, c2 from t_tset1 as t1 where exists ( select c1 from t_tset2
> where c1 = t1.c1 )
> Caused by: java.lang.RuntimeException:
> org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while
> processing row
> at
> org.apache.hadoop.hive.ql.exec.tez.MapRecordSource.processRow(MapRecordSource.java:91)
> at
> org.apache.hadoop.hive.ql.exec.tez.MapRecordSource.pushRecord(MapRecordSource.java:68)
> at
> org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.run(MapRecordProcessor.java:294)
> at
> org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:163)
> ... 13 more
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime
> Error while processing row
> at
> org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.process(VectorMapOperator.java:52)
> at
> org.apache.hadoop.hive.ql.exec.tez.MapRecordSource.processRow(MapRecordSource.java:83)
> ... 16 more
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unexpected
> exception: org.apache.hadoop.hive.serde2.io.HiveCharWritable cannot be cast
> to org.apache.hadoop.hive.common.type.HiveChar
> at
> org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:311)
> at
> org.apache.hadoop.hive.ql.exec.vector.VectorMapJoinOperator.processOp(VectorMapJoinOperator.java:249)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:815)
> at
> org.apache.hadoop.hive.ql.exec.vector.VectorFilterOperator.processOp(VectorFilterOperator.java:111)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:815)
> at
> org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:95)
> at
> org.apache.hadoop.hive.ql.exec.MapOperator$MapOpCtx.forward(MapOperator.java:157)
> at
> org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.process(VectorMapOperator.java:45)
> ... 17 more
> Caused by: java.lang.ClassCastException:
> org.apache.hadoop.hive.serde2.io.HiveCharWritable cannot be cast to
> org.apache.hadoop.hive.common.type.HiveChar
> at
> org.apache.hadoop.hive.ql.exec.vector.VectorColumnAssignFactory$18.assignObjectValue(VectorColumnAssignFactory.java:432)
> at
> org.apache.hadoop.hive.ql.exec.vector.VectorMapJoinOperator.internalForward(VectorMapJoinOperator.java:196)
> at
> org.apache.hadoop.hive.ql.exec.CommonJoinOperator.genAllOneUniqueJoinObject(CommonJoinOperator.java:670)
> at
> org.apache.hadoop.hive.ql.exec.CommonJoinOperator.checkAndGenObject(CommonJoinOperator.java:748)
> at
> org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:299)
> ... 24 more
> create table if not exists T_TSET1 (RNUM int , C1 int, C2 char(3))
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
> STORED AS textfile ;
> create table if not exists T_TSET1 (RNUM int , C1 int, C2 char(3))
> STORED AS ORC ;
> create table if not exists T_TSET2 (RNUM int , C1 int, C2 char(3))
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
> STORED AS textfile ;
> TSET1 data
> 0|10|AAA
> 1|10|AAA
> 2|10|AAA
> 3|20|BBB
> 4|30|CCC
> 5|40|DDD
> 6|50|\N
> 7|60|\N
> 8|\N|AAA
> 9|\N|AAA
> 10|\N|\N
> 11|\N|\N
> TSET2 DATA
> 0|10|AAA
> 1|10|AAA
> 2|40|DDD
> 3|50|EEE
> 4|60|FFF
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
