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)