[
https://issues.apache.org/jira/browse/TAJO-1403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14368107#comment-14368107
]
ASF GitHub Bot commented on TAJO-1403:
--------------------------------------
GitHub user dongjoon-hyun opened a pull request:
https://github.com/apache/tajo/pull/434
TAJO-1403: Improve 'Simple Query' with only partition columns and constant
values
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/dongjoon-hyun/tajo TAJO-1403
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/434.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 #434
----
commit ea2e948dcd838e42a5f92ce4e954d69265fcfa8d
Author: Dongjoon Hyun <[email protected]>
Date: 2015-03-18T23:11:05Z
TAJO-1403: Improve 'Simple Query' with only partition columns and constant
values
----
> Improve 'Simple Query' with only partition columns and constant values
> ----------------------------------------------------------------------
>
> Key: TAJO-1403
> URL: https://issues.apache.org/jira/browse/TAJO-1403
> Project: Tajo
> Issue Type: Improvement
> Reporter: Dongjoon Hyun
> Assignee: Dongjoon Hyun
> Fix For: 0.11.0
>
>
> Tajo shows a very fast response for a simple query (
> https://cwiki.apache.org/confluence/display/TAJO/Simple+Query+and+Forwarded+Query)
> like the followings.
> {code:sql}
> select * from t1 limit 10;
> {code}
> However, in many cases, tables have partitions.
> {code:sql}
> create external table t1(id int) using csv with ('csvfile.delimiter'='|')
> partition by column(dt text) location '/data';
> select * from t1 where dt='2015-03-15' limit 10;
> {code}
> If all predicates in WHERE consist of partition columns and 'EQUAL'
> predicates with constant values, I think Tajo can handle these cases very
> fast.
> This kind of queries is very popular for DevOps users and simple ETL apps.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
