[
https://issues.apache.org/jira/browse/TAJO-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dongjoon Hyun updated TAJO-1428:
--------------------------------
Description:
Tajo cannot handle min(date), max(date).
{code:sql}
default> create table t(a int, b date, c time, d timestamp);
OK
default> \d t
table name: default.t
table path: file:/tmp/tajo-djhyun/warehouse/default/t
store type: CSV
number of rows: 0
volume: 0 B
Options:
'text.delimiter'='|'
schema:
a INT4
b DATE
c TIME
d TIMESTAMP
default> select max(a) from t;
Progress: 0%, response time: 0.88 sec
Progress: 0%, response time: 0.881 sec
Progress: 100%, response time: 1.088 sec
?max
-------------------------------
(1 rows, 1.088 sec, 1 B selected)
default> select max(b) from t;
ERROR: function max(date) does not exist
default> select max(c) from t;
ERROR: function max(time) does not exist
default> select max(d) from t;
ERROR: function max(timestamp) does not exist
{code}
was:
Tajo cannot handle min(date), max(date).
{code:sql}
default> create table t_date(d date);
OK
default> insert into t_date select current_date();
(1 rows, 0.07 sec, 11 B inserted)
default> select * from t_date;
d
-------------------------------
2015-03-20
(1 rows, 0.138 sec, 11 B selected)
default> select max(d) from t_date;
ERROR: function max(date) does not exist
{code}
Summary: Support min, max for DATE, TIME, TIMESTAMP function (was:
Support min(DATE), max(DATE) function)
> Support min, max for DATE, TIME, TIMESTAMP function
> ---------------------------------------------------
>
> Key: TAJO-1428
> URL: https://issues.apache.org/jira/browse/TAJO-1428
> Project: Tajo
> Issue Type: Improvement
> Environment: Tajo 0.10.0
> Tajo 0.11.0-SNAPSHOT
> Reporter: Dongjoon Hyun
> Assignee: Dongjoon Hyun
>
> Tajo cannot handle min(date), max(date).
> {code:sql}
> default> create table t(a int, b date, c time, d timestamp);
> OK
> default> \d t
> table name: default.t
> table path: file:/tmp/tajo-djhyun/warehouse/default/t
> store type: CSV
> number of rows: 0
> volume: 0 B
> Options:
> 'text.delimiter'='|'
> schema:
> a INT4
> b DATE
> c TIME
> d TIMESTAMP
> default> select max(a) from t;
> Progress: 0%, response time: 0.88 sec
> Progress: 0%, response time: 0.881 sec
> Progress: 100%, response time: 1.088 sec
> ?max
> -------------------------------
> (1 rows, 1.088 sec, 1 B selected)
> default> select max(b) from t;
> ERROR: function max(date) does not exist
> default> select max(c) from t;
> ERROR: function max(time) does not exist
> default> select max(d) from t;
> ERROR: function max(timestamp) does not exist
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
