You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Jim Apple (JIRA)" <ji...@apache.org> on 2018/05/08 00:11:00 UTC
[jira] [Resolved] (IMPALA-6986) Inconsistent results for between
when date is string vs timestamp
[ 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)