[
https://issues.apache.org/jira/browse/HIVE-18627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16354352#comment-16354352
]
Gopal V commented on HIVE-18627:
--------------------------------
[~prasanth_j]: the tests already have
{code}
set hive.optimize.index.filter=false;
-- when cbo is disabled constant gets converted to HiveDecimal
select count(*) from orc_ppd where f=74.72;
set hive.optimize.index.filter=true;
select count(*) from orc_ppd where f=74.72;
set hive.cbo.enable=true;
set hive.optimize.index.filter=false;
select count(*) from orc_ppd where f=74.72;
set hive.optimize.index.filter=true;
select count(*) from orc_ppd where f=74.72;
{code}
> PPD: Handle FLOAT boxing differently for single/double precision constants
> --------------------------------------------------------------------------
>
> Key: HIVE-18627
> URL: https://issues.apache.org/jira/browse/HIVE-18627
> Project: Hive
> Issue Type: Bug
> Components: Types
> Reporter: Gopal V
> Assignee: Gopal V
> Priority: Major
> Attachments: HIVE-18627.1.patch
>
>
> Constants like 0.1 and 0.3 are differently boxed based on intermediate
> precision of the compiler codepath.
> Disabling CBO produces 0.1BD constants which fail to box correctly to
> Double/Float.
> Enabling CBO fixes this issue, but cannot be applied all queries in Hive.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
