[
https://issues.apache.org/jira/browse/TAJO-1126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14184920#comment-14184920
]
ASF GitHub Bot commented on TAJO-1126:
--------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/tajo/pull/209
> Join condition including functions throws IllegalArgumentException.
> -------------------------------------------------------------------
>
> Key: TAJO-1126
> URL: https://issues.apache.org/jira/browse/TAJO-1126
> Project: Tajo
> Issue Type: Bug
> Reporter: Hyoungjun Kim
> Assignee: Hyunsik Choi
> Priority: Minor
> Fix For: 0.9.1
>
>
> MergeJoin with function eval throws the following IllegalArgumentException.
> {code:sql}
> select
> n1.n_nationkey,
> n1.n_name,
> n2.n_name
> from nation n1 join (select * from nation union select * from nation) n2 on
> substr(n1.n_name, 1, 4) = substr(n2.n_name, 1, 4)
> order by n1.n_nationkey;
> {code}
> {noformat}
> java.lang.IllegalArgumentException: At least one sort key must be specified
> at
> com.google.common.base.Preconditions.checkArgument(Preconditions.java:88)
> at
> org.apache.tajo.engine.planner.logical.SortNode.setSortSpecs(SortNode.java:35)
> at
> org.apache.tajo.engine.planner.PhysicalPlannerImpl.createMergeInnerJoin(PhysicalPlannerImpl.java:443)
> at
> org.apache.tajo.engine.planner.PhysicalPlannerImpl.createBestInnerJoinPlan(PhysicalPlannerImpl.java:433)
> at
> org.apache.tajo.engine.planner.PhysicalPlannerImpl.createInnerJoinPlan(PhysicalPlannerImpl.java:377)
> at
> org.apache.tajo.engine.planner.PhysicalPlannerImpl.createJoinPlan(PhysicalPlannerImpl.java:292)
> at
> org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:218)
> at
> org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:207)
> at
> org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlan(PhysicalPlannerImpl.java:90)
> at
> org.apache.tajo.worker.TajoQueryEngine.createPlan(TajoQueryEngine.java:40)
> at org.apache.tajo.worker.Task.run(Task.java:442)
> at org.apache.tajo.worker.TaskRunner$1.run(TaskRunner.java:276)
> at java.lang.Thread.run(Thread.java:744)
> {noformat}
> The above query is from TestJoinQuery.testComplexJoinCondition7() test case.
> Currently TestJoinQuery runs with a parameterized option, but the parameter
> is not transmitted to UnitRequestImpl. So all test case run with HashJoin
> parameter. For this reason the above error is not detected. We should also
> fix the test case bug.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
