[
https://issues.apache.org/jira/browse/HIVE-24780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Panagiotis Garefalakis updated HIVE-24780:
------------------------------------------
Description:
{code:java}
set hive.cbo.enable=false;
create table comparison_table (col_v varchar(3), col_i int) stored as orc;
insert into comparison_table values ('001', 15), ('002', 25), ('007', 75);
select * from comparison_table where col_v >= 4L;
// Converts to pred '4' to String
// No result when CBO off
set hive.cbo.enable=on;
select * from comparison_table where col_v >= 4L;
// Converts both to Double
// 007 when CBO is on
{code}
was:Seems like hive.strict.timestamp.conversion,
hive.strict.checks.type.safety, hive.strict.checks.no.partition.filter etc. are
serving similar purpose
> Consistent type conversion with CBO on/off
> ------------------------------------------
>
> Key: HIVE-24780
> URL: https://issues.apache.org/jira/browse/HIVE-24780
> Project: Hive
> Issue Type: Sub-task
> Reporter: Panagiotis Garefalakis
> Priority: Major
>
> {code:java}
> set hive.cbo.enable=false;
> create table comparison_table (col_v varchar(3), col_i int) stored as orc;
> insert into comparison_table values ('001', 15), ('002', 25), ('007', 75);
> select * from comparison_table where col_v >= 4L;
> // Converts to pred '4' to String
> // No result when CBO off
> set hive.cbo.enable=on;
> select * from comparison_table where col_v >= 4L;
> // Converts both to Double
> // 007 when CBO is on
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
