[
https://issues.apache.org/jira/browse/HIVE-29375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Raghav Aggarwal updated HIVE-29375:
-----------------------------------
Description:
I am facing issue on running FULL OUTER JOIN
SET hive.vectorized.execution.enabled=true;
SET hive.execution.engine=tez;
CREATE TABLE join_table1 (
id INT,
event_date DATE
);
CREATE TABLE join_table2 (
id INT,
event_date DATE
);
SELECT t1.id, t1.event_date
FROM join_table1 t1
FULL OUTER JOIN join_table2 t2 ON t1.event_date = t2.event_date;
*Result:*
{code:java}
], TaskAttempt 2 failed, info=[Error: Node: Raghavs-MacBook-Pro.local/127.0.0.1
: Error while running task ( failure ) :
attempt_1765949959740_0001_2_02_000000_2:java.lang.RuntimeException:
java.lang.RuntimeException: Hive Runtime Error while closing operators:
Unexpected hash table key type DATE at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:341)
at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:276) at
org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:382)
at
org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:87)
at
org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:73)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
at java.base/javax.security.auth.Subject.doAs(Subject.java:525) at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:73)
at
org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:43)
at org.apache.tez.common.CallableWithNdc.call(CallableWithNdc.java:36) at
com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)
at
com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:75)
at
com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)Caused by:
java.lang.RuntimeException: Hive Runtime Error while closing operators:
Unexpected hash table key type DATE at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.close(ReduceRecordProcessor.java:384)
at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:321)
... 16 moreCaused by: java.lang.RuntimeException: Unexpected hash table
key type DATE at
org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinOuterGenerateResultOperator.generateFullOuterSmallTableNoMatches(VectorMapJoinOuterGenerateResultOperator.java:836)
at
org.apache.hadoop.hive.ql.exec.MapJoinOperator.closeOp(MapJoinOperator.java:739)
at
org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinGenerateResultOperator.closeOp(VectorMapJoinGenerateResultOperator.java:733)
at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:686)
at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.close(ReduceRecordProcessor.java:361)
... 17 more {code}
was:
I am facing issue on running FULL OUTER JOIN
SET hive.vectorized.execution.enabled=true;
SET hive.execution.engine=tez;
CREATE TABLE join_table1 (
id INT,
event_date DATE
);
CREATE TABLE join_table2 (
id INT,
event_date DATE
);
SELECT t1.id, t1.event_date
FROM join_table1 t1
FULL OUTER JOIN join_table2 t2 ON t1.event_date = t2.event_date;
*Result:*
ERROR : Vertex failed, vertexName=Reducer 2,
vertexId=vertex_1765331951128_0102_1_02, diagnostics=[Task failed,
taskId=task_1765331951128_0102_1_02_000001, diagnostics=[TaskAttempt 0 failed,
info=[Error: Node:server1.visa.com : Error while running task ( failure ) :
attempt_1765331951128_0102_1_02_000001_0:java.lang.RuntimeException:
java.lang.RuntimeException: Hive Runtime Error while closing operators:
Unexpected hash table key type DATE
at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:348)
at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:276)
at
org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:383)
at
org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:88)
at
org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:74)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:712)
at java.base/javax.security.auth.Subject.doAs(Subject.java:439)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:74)
at
org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:44)
at org.apache.tez.common.CallableWithNdc.call(CallableWithNdc.java:36)
at
com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)
at
com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:75)
at
com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: java.lang.RuntimeException: Hive Runtime Error while closing
operators: Unexpected hash table key type DATE
at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.close(ReduceRecordProcessor.java:379)
at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:310)
... 16 more
Caused by: java.lang.RuntimeException: Unexpected hash table key type DATE
at
org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinOuterGenerateResultOperator.generateFullOuterSmallTableNoMatches(VectorMapJoinOuterGenerateResultOperator.java:836)
at
org.apache.hadoop.hive.ql.exec.MapJoinOperator.closeOp(MapJoinOperator.java:739)
at
org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinGenerateResultOperator.closeOp(VectorMapJoinGenerateResultOperator.java:733)
at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:686)
at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.close(ReduceRecordProcessor.java:356)
... 17 more
> FULL OUTER JOIN is failing with Unexpected hash table key type DATE
> -------------------------------------------------------------------
>
> Key: HIVE-29375
> URL: https://issues.apache.org/jira/browse/HIVE-29375
> Project: Hive
> Issue Type: Bug
> Components: Vectorization
> Affects Versions: 4.0.1
> Reporter: chiranjeevi
> Assignee: Raghav Aggarwal
> Priority: Major
> Attachments: vector_full_outer_join_date.q
>
>
> I am facing issue on running FULL OUTER JOIN
> SET hive.vectorized.execution.enabled=true;
> SET hive.execution.engine=tez;
> CREATE TABLE join_table1 (
> id INT,
> event_date DATE
> );
> CREATE TABLE join_table2 (
> id INT,
> event_date DATE
> );
> SELECT t1.id, t1.event_date
> FROM join_table1 t1
> FULL OUTER JOIN join_table2 t2 ON t1.event_date = t2.event_date;
> *Result:*
> {code:java}
> ], TaskAttempt 2 failed, info=[Error: Node:
> Raghavs-MacBook-Pro.local/127.0.0.1 : Error while running task ( failure ) :
> attempt_1765949959740_0001_2_02_000000_2:java.lang.RuntimeException:
> java.lang.RuntimeException: Hive Runtime Error while closing operators:
> Unexpected hash table key type DATE at
> org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:341)
> at
> org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:276)
> at
> org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:382)
> at
> org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:87)
> at
> org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:73)
> at
> java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
> at java.base/javax.security.auth.Subject.doAs(Subject.java:525) at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
> at
> org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:73)
> at
> org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:43)
> at org.apache.tez.common.CallableWithNdc.call(CallableWithNdc.java:36)
> at
> com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)
> at
> com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:75)
> at
> com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
> at java.base/java.lang.Thread.run(Thread.java:1583)Caused by:
> java.lang.RuntimeException: Hive Runtime Error while closing operators:
> Unexpected hash table key type DATE at
> org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.close(ReduceRecordProcessor.java:384)
> at
> org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:321)
> ... 16 moreCaused by: java.lang.RuntimeException: Unexpected hash table
> key type DATE at
> org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinOuterGenerateResultOperator.generateFullOuterSmallTableNoMatches(VectorMapJoinOuterGenerateResultOperator.java:836)
> at
> org.apache.hadoop.hive.ql.exec.MapJoinOperator.closeOp(MapJoinOperator.java:739)
> at
> org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinGenerateResultOperator.closeOp(VectorMapJoinGenerateResultOperator.java:733)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:686)
> at
> org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.close(ReduceRecordProcessor.java:361)
> ... 17 more {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
