tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TAJO-46) The "having" clause does not work properly
Date Sat, 21 Sep 2013 02:18:51 GMT

    [ https://issues.apache.org/jira/browse/TAJO-46?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13773688#comment-13773688
] 

Hudson commented on TAJO-46:
----------------------------

SUCCESS: Integrated in Tajo-trunk-postcommit #462 (See [https://builds.apache.org/job/Tajo-trunk-postcommit/462/])
TAJO-46: The "having" clause does not work properly. (hyunsik) (hyunsik: https://git-wip-us.apache.org/repos/asf?p=incubator-tajo.git&a=commit&h=e595384bace80341c23575a554cd21a95fb19738)
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/LogicalPlanVisitor.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/physical/HashAggregateExec.java
* tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/master/TestGlobalPlanner.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/ExplainLogicalPlanVisitor.java
* tajo-algebra/src/main/java/org/apache/tajo/algebra/LiteralValue.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/GlobalPlanner.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/EvalNodeVisitor2.java
* CHANGES.txt
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/parser/SQLAnalyzer.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/Target.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/logical/GroupbyNode.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/RowConstantEval.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/PhysicalPlannerImpl.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/rewrite/ProjectionPushDownRule.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/parser/HiveConverter.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/RowConstant.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/LogicalPlanner.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/BasicEvalNodeVisitor.java
* tajo-common/src/main/java/org/apache/tajo/util/TUtil.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/InEval.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/BaseAlgebraVisitor.java
* tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/query/TestGroupByQuery.java
* tajo-algebra/src/main/java/org/apache/tajo/algebra/Target.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/AlgebraVisitor.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/CaseWhenEval.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/EvalType.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/EvalNodeVisitor.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/physical/AggregationExec.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/NotEval.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/EvalTreeUtil.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/LogicalPlan.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/BasicLogicalPlanVisitor.java

                
> The "having" clause does not work properly
> ------------------------------------------
>
>                 Key: TAJO-46
>                 URL: https://issues.apache.org/jira/browse/TAJO-46
>             Project: Tajo
>          Issue Type: Bug
>          Components: planner/optimizer
>            Reporter: Hyoseok Ryu
>            Assignee: Hyunsik Choi
>            Priority: Critical
>             Fix For: 0.2-incubating
>
>         Attachments: TAJO-46.patch
>
>
> I used the following query for testing 
> {code}
> select client, count(requestaddr) as req_cnt from  weblog_day_20130407 where timestamp
> 1365332400 and timestamp < 1365333600 group by client having req_cnt > 5
> {code}
> The result of the query includes tuples which does not satisfy the having predicate "req_cnt
> 5".
> {code}
> client,  req_cnt
> -------------------------------
> 182.242.126.67,  7
> 117.4.43.183,  2
> 180.175.60.23,  2
> 111.121.67.70,  7
> 223.65.142.52,  7
> 171.252.149.187,  246
> 2.94.0.205,  4
> 183.36.65.68,  9
> 221.214.213.226,  4
> 113.240.238.196,  1
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message