impala-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nicholas Brenwald (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IMPALA-5336) Inconsistent results when comparing string and timestamp fields
Date Thu, 18 May 2017 13:34:04 GMT
Nicholas Brenwald created IMPALA-5336:
-----------------------------------------

             Summary: Inconsistent results when comparing string and timestamp fields
                 Key: IMPALA-5336
                 URL: https://issues.apache.org/jira/browse/IMPALA-5336
             Project: IMPALA
          Issue Type: Bug
          Components: Backend
    Affects Versions: Impala 2.7.0
         Environment: CDH 5.10.1
            Reporter: Nicholas Brenwald


{code}
create table t1 (c1 string, c2 string);
insert into t1 values ('a string', '2017-01-01');
create table t2 (c1 string) partitioned by (c2 string);
insert into t2 partition (c2) values ('a string', '2017-01-01');
{code}

This correctly returns 1 row
{code}
select * from t1 where c2 = cast('2017-01-01' as timestamp);
{code}

This incorrectly returns 0 rows
{code}
select * from t2 where c2 = cast('2017-01-01' as timestamp);
{code}

This bug was not present in version:
Server version: impalad version 2.6.0-cdh5.8.2 RELEASE (build f25aa5b2bcdabf1eb4233747a7b04a067059ee3b)"

But is present in version:
Server version: impalad version 2.7.0-cdh5.10.1 RELEASE (build 876895d2a90346e69f2aea02d5528c2125ae7a32)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message