You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/08 00:55:27 UTC
[jira] [Updated] (TRAFODION-23) Keyed nested join in TPCH query 2
and 15 disappeared recently
[ https://issues.apache.org/jira/browse/TRAFODION-23?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah updated TRAFODION-23:
------------------------------------
Component/s: sql-cmp
> 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
> Components: sql-cmp
> 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)