Jesus Camacho Rodriguez created HIVE-23222:
----------------------------------------------
Summary: Missed opportunity in IN merge
Key: HIVE-23222
URL: https://issues.apache.org/jira/browse/HIVE-23222
Project: Hive
Issue Type: Improvement
Components: CBO
Affects Versions: 4.0.0
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
After HIVE-23100 went in, there was a missed opportunity merging IN clauses,
which can be seen in
ql/src/test/results/clientpositive/llap/vector_between_in.q.out .
{code}
filterExpr: (cdecimal1) IN (2365.8945945946, 881.0135135135,
-3367.6517567568) (type: boolean)
{code}
was replaced by:
{code}
filterExpr: ((cdecimal1) IN (2365.8945945946,
-3367.6517567568) or (cdecimal1) IN (881.0135135135)) (type: boolean)
{code}
The problem seems to be that with decimal type, we are considering values with
different precision/scale as a different type, thus we do not merge them.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
