[
https://issues.apache.org/jira/browse/TRAFODION-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16596662#comment-16596662
]
Sandhya Sundaresan commented on TRAFODION-3192:
-----------------------------------------------
|another queue sizing problem on TRANSPOSE operator we found at JPMC
After investigating the issue with Suresh,
We found a potential couple of CQD that are worth trying:
GEN_TRSP_SIZE_DOWN ‘2048’;
GEN_TRSP_SIZE_UP ‘2048’;
These regulate the size of the up and down queue of the Transpose operator that
we suspect is causing bottleneck.|
> UNION ALL up and down queue size default value too small, or not dynamically
> adjusted
> -------------------------------------------------------------------------------------
>
> Key: TRAFODION-3192
> URL: https://issues.apache.org/jira/browse/TRAFODION-3192
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: any
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
> Priority: Major
> Fix For: 2.4
>
>
> The union up queue size is hardcoded in nadefaults.cpp as a start value as 16
> which
> is very low if large number of rows are being returned. Scan operator has it
> set to 2048.
> Some operators further adjust this up size from the original value based on
> estimate of
> the number of rows being returned. We can do that for union codegen method and
> also change the original up queue size to 2048.
>
> Noticed that Transpose, Sequence also have the same issue and dynamic queue
> resizing is missing.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
