[ 
https://issues.apache.org/jira/browse/TRAFODION-23?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Work on TRAFODION-23 stopped by Qifan Chen.
-------------------------------------------
> 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
>            Assignee: Qifan Chen
>              Labels: performance
>
> 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)

Reply via email to