[
https://issues.apache.org/jira/browse/TAJO-1403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dongjoon Hyun updated TAJO-1403:
--------------------------------
Description:
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.
was:
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 has 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, Tajo also handle this cases very fast.
This kind of queries are very popular for DevOps users and simple ETL apps.
> 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
>
> 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)
