[
https://issues.apache.org/jira/browse/TAJO-1403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14367191#comment-14367191
]
Dongjoon Hyun commented on TAJO-1403:
-------------------------------------
Thank you for your review, [~jihoonson].
As I mentioned in my pull request. I tested like this. (Travis CI maven command)
{code}
mvn clean install -Pparallel-test,hcatalog-0.12.0 -DLOG_LEVEL=ERROR
-Dmaven.fork.count=2
-----
Tests run: 1376, Failures: 0, Errors: 0, Skipped: 0
{code}
After your review, I checked again. But, I can not regenerate the failure. At
this time, I used the Jenkins maven command to get the same result with
Jenkins.
{code}
$ mvn clean test -Phcatalog-0.12.0 -DLOG_LEVEL=ERROR >
mvn_clean_test_Phcatalog-0.12.0
------
Tests run: 1376, Failures: 0, Errors: 0, Skipped: 0
{code}
Here is my new test result text file.
https://app.box.com/s/zf589fb3o03rhmchk1y70kvu1fdeawoz
I'm not sure about the reason. Have you ever experienced something like this?
In my opinion, could you pull and check in your environment, please?
Regards,
Dongjoon.
> 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
>
> Attachments: TAJO-1403.patch
>
>
> 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)
