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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
