[jira] [Created] (KYLIN-2435) two EXTRACT on a column will fail if there exists NULL values for the column

["hongbin ma (JIRA)" <ji...@apache.org>]

hongbin ma created KYLIN-2435:
---------------------------------

             Summary: two EXTRACT on a column will fail if there exists NULL values for the column
                 Key: KYLIN-2435
                 URL: https://issues.apache.org/jira/browse/KYLIN-2435
             Project: Kylin
          Issue Type: Bug
            Reporter: hongbin ma
            Assignee: hongbin ma


2000-01-01 19:12:33,US,android,10.22
2001-01-01 9:12:33,US,windows,9.12
2002-05-02 20:12:03,CN,windows,3.33
\N,CN,windows,3.32

create table testtable (starttime TIMESTAMP,country STRING, client STRING, price DECIMAL(18,4)) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';

the following query will succeed:

{code}
select sum(price),extract (year from starttime) from testtable group by extract (year from starttime)
{code}

but the following will fail:

{code}
select sum(price) from testtable group by extract (year from starttime), extract (month from starttime)
{code}



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