You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "Mala Chikka Kempanna (JIRA)" <ji...@apache.org> on 2018/05/07 22:43:00 UTC

[jira] [Created] (IMPALA-6986) Inconsistent results for between when date is string vs timestamp

Mala Chikka Kempanna created IMPALA-6986:
--------------------------------------------

             Summary: 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


Following two queries run on same dataset should return same output. But they are not.

{code}

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}
+-----------------+
| count(timespan) |
+-----------------+
| 254 |
+-----------------+



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)