Sathyendra created HIVE-25743:
---------------------------------
Summary: Hive INSERT Query to transactional table fails with
HiveException: Unexpected column vector type STRUCT
Key: HIVE-25743
URL: https://issues.apache.org/jira/browse/HIVE-25743
Project: Hive
Issue Type: Bug
Components: Hive, Query Processor, Vectorization
Affects Versions: 3.1.2
Reporter: Sathyendra
Hive insert query with join on transactional table fails with HiveException:
Unexpected column vector type STRUCT.
Repro Queries:
{{CREATE TABLE tab_s(a int) STORED AS ORC TBLPROPERTIES
('orc.compress'='SNAPPY');}}
{{INSERT INTO tab_s values(1);}}
{{CREATE TABLE tab_t(a int) STORED AS ORC TBLPROPERTIES
('orc.compress'='SNAPPY','transactional'='true');}}
{{INSERT INTO tab_t select * from tab_s;}}
{{DELETE FROM tab_t WHERE EXISTS (select tab_s.a from tab_s where
tab_s.a=tab_t.a);}}
----
+*Workaround:*+
This issue is seen with {+}*vectorized execution enabled*{+}. If we disable the
vectorization, the query will run smoothly.
Property value change:
{{{_}hive.vectorized.execution.enabled{_}={*}false{*}}} on cluster
{{hive-site.xml}}
----
+*Log:*+ (Full attached)
{{Caused by: java.lang.RuntimeException: Map operator initialization failed}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:266)}}
{{ ... 16 more}}
{{Caused by: org.apache.hadoop.hive.ql.metadata.HiveException:
*{color:#de350b}Unexpected column vector type STRUCT{color}*}}
{{ at
org.apache.hadoop.hive.ql.exec.vector.VectorCopyRow.init(VectorCopyRow.java:302)}}
{{ at
org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinCommonOperator.initializeOp(VectorMapJoinCommonOperator.java:419)}}
{{ at
org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinGenerateResultOperator.initializeOp(VectorMapJoinGenerateResultOperator.java:115)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:376)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:573)}}
{{ at
org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:525)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:386)}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:335)}}
{{ ... 17 more}}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
