[jira] [Created] (TAJO-1732) Non-join conditions in the ON clause are identified as join conditions mistakenly

["Jihoon Son (JIRA)" <ji...@apache.org>]

Jihoon Son created TAJO-1732:
--------------------------------

             Summary: Non-join conditions in the ON clause are identified as join conditions mistakenly
                 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)