You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Bikramjeet Vig (Jira)" <ji...@apache.org> on 2022/03/25 01:14:00 UTC
[jira] [Created] (IMPALA-11200) Redundant additions to ExecOption field in query profile of grouping aggregator node when inside a subplan
Bikramjeet Vig created IMPALA-11200:
---------------------------------------
Summary: Redundant additions to ExecOption field in query profile of grouping aggregator node when inside a subplan
Key: IMPALA-11200
URL: https://issues.apache.org/jira/browse/IMPALA-11200
Project: IMPALA
Issue Type: Bug
Reporter: Bikramjeet Vig
There is an excessive addition of "Codegen Enabled" text to "ExecOption" field in the query profile when a grouping agg is a part of a subplan that is created to unnest a complex type.
I was able to reproduce this using one of the queries we used for end to end testing:
{noformat}
use tpch_nested_parquet;
select c_custkey, v.* from customer c,
(select o_orderpriority, count(o_orderkey) c, sum(o_totalprice) s,
avg(o_totalprice) a, max(o_orderstatus) mx,
min(o_orderdate) mn
from c.c_orders
group by o_orderpriority) v
where c_custkey < 4;
{noformat}
From the query profile:
{noformat}
AGGREGATION_NODE (id=4):
- InactiveTotalTime: 0.000ns
- PeakMemoryUsage: 36.04 MB (37794944)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- TotalTime: 1.571ms
GroupingAggregator 0:
ExecOption: Codegen Enabled, Codegen Enabled, Codegen Enabled <== THIS PART!
- BuildTime: 68.253us
- GetResultsTime: 72.634us
{noformat}
The reason this happens is because "Codegen Enabled" is added to the ExecOption everytime the agg node is Opened as a result of the subplan being called again and again to unnest.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org