[jira] [Created] (TRAFODION-23) Keyed nested join in TPCH query 2 and 15 disappeared recently

["Qifan Chen (JIRA)" <ji...@apache.org>]

Qifan Chen created TRAFODION-23:
-----------------------------------

             Summary: Keyed nested join in TPCH query 2 and 15 disappeared recently
                 Key: TRAFODION-23
                 URL: https://issues.apache.org/jira/browse/TRAFODION-23
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: Qifan Chen


Good keyed nested join in TPCH query 2 and 15 disappeared in recent performance test (close to the ones dated 06222015). Each is replaced by a hash join which is more expensive to evaluate. 

To fix this case, we can take the following approach. 

1. Modify the earlier versions of Trafodion so that they compile without log4cpp;
2. Install the versions on a cluster and run the two queries
3. Identity the earliest version of Trafodion in which the NJ->HJ takes place
4. Analyze the code change to isolate the root cause



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)