[
https://issues.apache.org/jira/browse/IMPALA-6986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jim Apple resolved IMPALA-6986.
-------------------------------
Resolution: Not A Bug
> Inconsistent results for between when date is string vs timestamp
> -----------------------------------------------------------------
>
> Key: IMPALA-6986
> URL: https://issues.apache.org/jira/browse/IMPALA-6986
> Project: IMPALA
> Issue Type: Bug
> Affects Versions: Impala 2.11.0
> Reporter: Mala Chikka Kempanna
> Priority: Major
> Labels: correctness
>
> Following two queries run on same dataset should return same output. But they
> are not.
> This happens only with parquet data loaded on impala version 2.3.0 and
> queries from Impala 2.11.0 after upgrade.
> {code:java}
> select count(timespan) from metrics where timespan between
> cast(date_add('2018-04-06 14:37:00' , -7) as string) and '2018-04-06
> 14:37:00';
> +-----------------+
> | count(timespan) |
> +-----------------+
> | 1095 |
> +-----------------+
> select count(timespan) from metrics where timespan between
> date_add('2018-04-06 14:37:00' , -7) and '2018-04-06 14:37:00';
> {code}
> {code}
> +-----------------+
> |count(timespan)|
> +-----------------+
> |254|
> +-----------------+
>
> {code:java}
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
