[jira] [Commented] (HIVE-28722) Missing implicit string to date cast leads to data correctness issue when CBO is off

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-28722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17916387#comment-17916387 ] 

Stamatis Zampetakis commented on HIVE-28722:
--------------------------------------------

All improvements/fixes in the non-CBO path have low priority and may never get fixed. Disabling CBO is not recommended and the property will disappear in the near future (HIVE-27830).

> Missing implicit string to date cast leads to data correctness issue when CBO is off
> ------------------------------------------------------------------------------------
>
>                 Key: HIVE-28722
>                 URL: https://issues.apache.org/jira/browse/HIVE-28722
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Krisztian Kasa
>            Priority: Minor
>
> Repro
> {code}
> create table t1 (a string, b int);
> insert into t1 values ('2014-03-14 10:10:12', 10);
> set hive.cbo.enable=false;
> select * from t1 where a between date_add('2014-03-14', -1) and '2014-03-14';
> {code}
> The query does not return any row but it should return
> {code}
> 2014-03-14 10:10:12	10
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)