Pengcheng Xiong created HIVE-10455:
--------------------------------------
Summary: CBO (Calcite Return Path): Different data types at
Reducer before JoinOp
Key: HIVE-10455
URL: https://issues.apache.org/jira/browse/HIVE-10455
Project: Hive
Issue Type: Sub-task
Reporter: Pengcheng Xiong
Assignee: Pengcheng Xiong
The following error occured for cbo_subq_not_in.q
{code}
java.lang.Exception: java.lang.RuntimeException:
org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error: Unable to
deserialize reduce input key from x1x128x0x0x1 with properties
{columns=reducesinkkey0,
serialization.lib=org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe,
serialization.sort.order=+, columns.types=double}
at
org.apache.hadoop.mapred.LocalJobRunner$Job.runTasks(LocalJobRunner.java:462)
at
org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:529)
{code}
A more easier way to reproduce is
{code}
set hive.cbo.enable=true;
set hive.exec.check.crossproducts=false;
set hive.stats.fetch.column.stats=true;
set hive.auto.convert.join=false;
select p_size, src.key
from
part join src
on p_size=key;
{code}
As you can see, p_size is integer while src.key is string. Both of them should
be cast to double when they join. When return path is off, this will happen
before Join, at RS. However, when return path is on, this will be considered as
an expression in Join. Thus, when reducer is collecting different types of keys
from different join branches, it throws exception.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
