[
https://issues.apache.org/jira/browse/HIVE-15708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15904990#comment-15904990
]
Remus Rusanu commented on HIVE-15708:
-------------------------------------
_Almost_ there :)
The orc_ppd_decimal is understood, is it caused by the introduction of
implicit CAST operators for `IN` (needed primarily for TIMESTAMP vs. string
comparisons during constant reduction in Calcite). In this test the expression
{{d IN ('0.9', CAST('11.22' as float))}} where {{d}} is a decimal gets
converted to {{CAST(d as double) IN (CAST('0.9' as double), CAST(CAST('11.22'
as float) as double))}}, which is actually correct. But {{(CAST(CAST('11.22' as
float) as double)}} yields {{11.220000267028809}} and this modifies the rows
that qualify.
> Upgrade calcite version to 1.12
> -------------------------------
>
> Key: HIVE-15708
> URL: https://issues.apache.org/jira/browse/HIVE-15708
> Project: Hive
> Issue Type: Task
> Components: CBO, Logical Optimizer
> Affects Versions: 2.2.0
> Reporter: Ashutosh Chauhan
> Assignee: Remus Rusanu
> Attachments: HIVE-15708.01.patch, HIVE-15708.02.patch,
> HIVE-15708.03.patch, HIVE-15708.04.patch, HIVE-15708.05.patch,
> HIVE-15708.06.patch, HIVE-15708.07.patch, HIVE-15708.08.patch,
> HIVE-15708.09.patch, HIVE-15708.10.patch, HIVE-15708.11.patch,
> HIVE-15708.12.patch, HIVE-15708.13.patch, HIVE-15708.14.patch,
> HIVE-15708.15.patch, HIVE-15708.15.patch, HIVE-15708.16.patch
>
>
> Currently we are on 1.10 Need to upgrade calcite version to 1.11
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
