[jira] [Created] (TAJO-1011) EvalTreeUtil::isJoinQual need to handle other join conditions.

["Jaehwa Jung (JIRA)" <ji...@apache.org>]

Jaehwa Jung created TAJO-1011:
---------------------------------

             Summary: EvalTreeUtil::isJoinQual need to handle other join conditions.
                 Key: TAJO-1011
                 URL: https://issues.apache.org/jira/browse/TAJO-1011
             Project: Tajo
          Issue Type: Bug
          Components: planner/optimizer
            Reporter: Jaehwa Jung
            Assignee: Jaehwa Jung


Currently, EvalTreeUtil::isJoinQual doesn't handle as follows:

{code:title=Constant field|borderStyle=solid}
select * from lineitem where l_orderkey = 2;
{code}

{code:title=Alias field using function|borderStyle=solid}
select   n1.n_nationkey,   substr(n1.n_name, 1, 4) name1,   substr(n2.n_name, 1, 4) name2
from nation n1 join nation n2 on substr(n1.n_name, 1, 4) = substr(n2.n_name, 1, 4)
order by n1.n_nationkey;
{code}

To above cases, current tajo can't pass unit test cases as follows:
{code:xml}
Failed tests:   testBroadcastPartitionTable(org.apache.tajo.engine.query.TestJoinBroadcast): Table [customer_broad_parts] creation is failed.
  testPartitionMultiplePartitionFilter(org.apache.tajo.engine.query.TestJoinOnPartitionedTables): Table [customer_parts] creation is failed.
  testFilterPushDownPartitionColumnCaseWhen(org.apache.tajo.engine.query.TestJoinOnPartitionedTables): Table [customer_parts] creation is failed.
  testRightOuterJoinPredicationCaseByCase3[0](org.apache.tajo.engine.query.TestJoinQuery): expected:<[id,name,id,id(..)
  testLeftOuterJoinPredicationCaseByCase3[0](org.apache.tajo.engine.query.TestJoinQuery): expected:<[id,name,id,id(..)
  testComplexJoinCondition4[0](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...-------(..)
  testComplexJoinCondition5[0](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...-------(..)
  testComplexJoinCondition6[0](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...0,ALGE,ALGE(..)
  testOuterJoinAndCaseWhen1[0](org.apache.tajo.engine.query.TestJoinQuery): Table [table1] creation is failed.
  testRightOuterJoinPredicationCaseByCase3[1](org.apache.tajo.engine.query.TestJoinQuery): expected:<[id,name,id,id(..)
  testLeftOuterJoinPredicationCaseByCase3[1](org.apache.tajo.engine.query.TestJoinQuery): expected:<[id,name,id,id(..)
  testComplexJoinCondition4[1](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...-------(..)
  testComplexJoinCondition5[1](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...-------(..)
  testComplexJoinCondition6[1](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...0,ALGE,ALGE(..)
  testOuterJoinAndCaseWhen1[1](org.apache.tajo.engine.query.TestJoinQuery): Table [table1] creation is failed.
  testComplexJoinCondition4[2](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...-------(..)
  testComplexJoinCondition5[2](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...-------(..)
  testComplexJoinCondition6[2](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...0,ALGE,ALGE(..)
  testOuterJoinAndCaseWhen1[2](org.apache.tajo.engine.query.TestJoinQuery): Table [table1] creation is failed.
  testComplexJoinCondition4[3](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...-------(..)
  testComplexJoinCondition5[3](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...-------(..)
  testComplexJoinCondition6[3](org.apache.tajo.engine.query.TestJoinQuery): Result Verification expected:<...0,ALGE,ALGE(..)
  testOuterJoinAndCaseWhen1[3](org.apache.tajo.engine.query.TestJoinQuery): Table [table1] creation is failed.
  testSortWithDate(org.apache.tajo.engine.query.TestSortQuery): Table [table1] creation is failed.

Tests in error:
  testQ2FourJoins(org.apache.tajo.benchmark.TestTPCH): java.util.NoSuchElementException(..)
  testCastFromTable(org.apache.tajo.engine.eval.TestSQLExpression)
  testEqual(org.apache.tajo.engine.planner.physical.TestBSTIndexExec)
  testCreateScanWithFilterPlan(org.apache.tajo.engine.planner.physical.TestPhysicalPlanner)
  testProjectionPush(org.apache.tajo.engine.planner.TestLogicalOptimizer)
  testOptimizeWithGroupBy(org.apache.tajo.engine.planner.TestLogicalOptimizer)
  testJoinWithMultipleJoinQual2(org.apache.tajo.engine.planner.TestLogicalPlanner)
  testJoinWithMultipleJoinQual3(org.apache.tajo.engine.planner.TestLogicalPlanner)
  testJoinWithMultipleJoinQual4(org.apache.tajo.engine.planner.TestLogicalPlanner)
{code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)