[jira] [Created] (IMPALA-12383) Aggregation with num_nodes=1 and limit returns too many rows

2023-08-17 Thread Michael Smith (Jira) 
Michael Smith created IMPALA-12383:
--

 Summary: Aggregation with num_nodes=1 and limit returns too many 
rows
 Key: IMPALA-12383
 URL: https://issues.apache.org/jira/browse/IMPALA-12383
 Project: IMPALA
  Issue Type: Bug
  Components: Backend, Frontend
Affects Versions: Impala 4.1.0
Reporter: Michael Smith


With {{set num_nodes=1}} to select SingleNodePlanner, aggregations return too 
many rows:
{code}
> select distinct l_orderkey from tpch.lineitem limit 10;
...
Fetched 16 row(s) in 0.12s
> select ss_cdemo_sk from tpcds.store_sales group by ss_cdemo_sk limit 3;
...
Fetched 7 row(s) in 0.14s
{code}

This looks like it's caused by changes in IMPALA-2581, which attempts to push 
down limits to pre-aggregation. In SingleNodePlanner, there is no 
pre-aggregation, which the patch appears to have failed to account for.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Created] (IMPALA-12383) Aggregation with num_nodes=1 and limit returns too many rows

2023-08-17 Thread Michael Smith (Jira) 
Michael Smith created IMPALA-12383:
--

 Summary: Aggregation with num_nodes=1 and limit returns too many 
rows
 Key: IMPALA-12383
 URL: https://issues.apache.org/jira/browse/IMPALA-12383
 Project: IMPALA
  Issue Type: Bug
  Components: Backend, Frontend
Affects Versions: Impala 4.1.0
Reporter: Michael Smith


With {{set num_nodes=1}} to select SingleNodePlanner, aggregations return too 
many rows:
{code}
> select distinct l_orderkey from tpch.lineitem limit 10;
...
Fetched 16 row(s) in 0.12s
> select ss_cdemo_sk from tpcds.store_sales group by ss_cdemo_sk limit 3;
...
Fetched 7 row(s) in 0.14s
{code}

This looks like it's caused by changes in IMPALA-2581, which attempts to push 
down limits to pre-aggregation. In SingleNodePlanner, there is no 
pre-aggregation, which the patch appears to have failed to account for.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

-
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org