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)
