Dongjoon Hyun created TAJO-1403:
-----------------------------------

             Summary: 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 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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to