You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/07/31 04:59:04 UTC
[jira] [Commented] (TAJO-1732) During filter push down phase, join
conditions are not set properly
[ https://issues.apache.org/jira/browse/TAJO-1732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14648673#comment-14648673 ]
ASF GitHub Bot commented on TAJO-1732:
--------------------------------------
GitHub user jihoonson opened a pull request:
https://github.com/apache/tajo/pull/670
TAJO-1732: During filter push down phase, join conditions are not set properly
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/jihoonson/tajo-2 TAJO-1732
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/670.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #670
----
commit 7a3a24936dcfcf47e2b64befaecb6a8b1b1720a3
Author: Jihoon Son <ji...@apache.org>
Date: 2015-07-31T02:56:15Z
TAJO-1732
----
> During filter push down phase, join conditions are not set properly
> -------------------------------------------------------------------
>
> Key: TAJO-1732
> URL: https://issues.apache.org/jira/browse/TAJO-1732
> Project: Tajo
> Issue Type: Bug
> Components: Planner/Optimizer
> Reporter: Jihoon Son
> Assignee: Jihoon Son
> Fix For: 0.11.0
>
>
> See the title.
> You can reproduce with this query.
> {noformat}
> default> select
> n1.n_name as supp_nation, n2.n_name as cust_nation, n1.n_nationkey as s_nationkey, n2.n_nationkey as c_nationkey
> from
> nation n1 join nation n2
> on
> n1.n_name = 'FRANCE' and n2.n_name = 'GERMANY'
> UNION ALL
> select
> n1.n_name as supp_nation, n2.n_name as cust_nation, n1.n_nationkey as s_nationkey, n2.n_nationkey as c_nationkey
> from
> nation n1 join nation n2
> on
> n2.n_name = 'FRANCE' and n1.n_name = 'GERMANY'
> {noformat}
> This query causes an NPE as follow:
> {noformat}
> 2015-07-31 11:06:38,255 ERROR org.apache.tajo.worker.TaskImpl:
> java.lang.NullPointerException
> at org.apache.tajo.plan.util.PlannerUtil.getJoinKeyPairs(PlannerUtil.java:675)
> at org.apache.tajo.engine.planner.physical.CommonHashJoinExec.<init>(CommonHashJoinExec.java:64)
> at org.apache.tajo.engine.planner.physical.HashJoinExec.<init>(HashJoinExec.java:32)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createBestInnerJoinPlan(PhysicalPlannerImpl.java:439)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createInnerJoinPlan(PhysicalPlannerImpl.java:385)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createJoinPlan(PhysicalPlannerImpl.java:300)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:220)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlan(PhysicalPlannerImpl.java:92)
> at org.apache.tajo.worker.TajoQueryEngine.createPlan(TajoQueryEngine.java:40)
> at org.apache.tajo.worker.TaskImpl.run(TaskImpl.java:396)
> at org.apache.tajo.worker.TaskContainer.run(TaskContainer.java:65)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)