You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sathyendra (Jira)" <ji...@apache.org> on 2021/11/29 10:33:00 UTC
[jira] [Updated] (HIVE-25743) Hive INSERT Query with join condition on transactional table fails with HiveException: Unexpected column vector type STRUCT
[ https://issues.apache.org/jira/browse/HIVE-25743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sathyendra updated HIVE-25743:
------------------------------
Summary: Hive INSERT Query with join condition on transactional table fails with HiveException: Unexpected column vector type STRUCT (was: Hive INSERT Query to transactional table fails with HiveException: Unexpected column vector type STRUCT)
> Hive INSERT Query with join condition on 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
> Priority: Critical
>
> 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)