[
https://issues.apache.org/jira/browse/TAJO-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14375211#comment-14375211
]
ASF GitHub Bot commented on TAJO-1428:
--------------------------------------
GitHub user dongjoon-hyun opened a pull request:
https://github.com/apache/tajo/pull/449
TAJO-1428: Support min, max builtin functions for DATE, TIME, TIMESTAMP
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/dongjoon-hyun/tajo TAJO-1428
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/449.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #449
----
commit 5f166f5985551136219f8c37c08353e5a6be96ff
Author: Dongjoon Hyun <[email protected]>
Date: 2015-03-22T22:55:28Z
TAJO-1428: Support min, max builtin functions for DATE, TIME, TIMESTAMP
----
> 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
> 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)
