liukun4515 commented on issue #10630:
URL: https://github.com/apache/datafusion/issues/10630#issuecomment-2126290921
my sql is like:
```
select
LO_SUPPKEY
from
SSB_1G.LINEORDER
GROUP BY
LO_SUPPKEY
limit 20 offset 10
```
The stand-alone physical plan is:
The agg exec add the limit value in the plan after the rule of
`LimitedDistinctAggregation`, but it does not take effect when we send the
physical plan to remote side.
```
GlobalLimitExec: skip=10, fetch=20
CoalescePartitionsExec
LocalLimitExec: fetch=30
AggregateExec: mode=FinalPartitioned, gby=[LO_SUPPKEY@0 as
LO_SUPPKEY], aggr=[], lim=[30]
CoalesceBatchesExec: target_batch_size=8192
RepartitionExec: partitioning=Hash([LO_SUPPKEY@0], 16),
input_partitions=16
RepartitionExec: partitioning=RoundRobinBatch(16),
input_partitions=2
AggregateExec: mode=Partial, gby=[LO_SUPPKEY@0 as LO_SUPPKEY],
aggr=[], lim=[30]
ProjectionExec: expr=[2@0 as LO_SUPPKEY]
ParquetExec: file_groups={2 groups:
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
