Sandhya Sundaresan created TRAFODION-3192:
---------------------------------------------
Summary: 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
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)
