[
https://issues.apache.org/jira/browse/TAJO-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dongjoon Hyun updated TAJO-1428:
--------------------------------
Attachment: TAJO-1428.patch
> Support min, max builtin functions for DATE, TIME, TIMESTAMP function
> ---------------------------------------------------------------------
>
> Key: TAJO-1428
> URL: https://issues.apache.org/jira/browse/TAJO-1428
> Project: Tajo
> Issue Type: Improvement
> Affects Versions: 0.10.0
> Environment: Tajo 0.10.0
> Tajo 0.11.0-SNAPSHOT
> Reporter: Dongjoon Hyun
> Assignee: Dongjoon Hyun
> Attachments: TAJO-1428.patch
>
>
> 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)
