<!here> I am implementing the pagination use-case based on https://pinot.apache.org/docs/user-guide/pql/#pagination-on-selection .I found out that pagination only works without distinct clause but not when distinct is included.Is that a limitation or a bug ?

Distinct is currently modeled as an aggregation function, not selection.

Thanks Mayank.Distinct does work with aggregation as well https://docs.pinot.apache.org/configuration-reference/functions/distinct

I meant that pagination is supported for

selection

and not

aggregation

, and Distinct is implemented as

aggregation

, which probably explains the reason for what you are seeing.

Ok is that going to be added in future release ?

I think @Atri Sharma was planning on picking it up.

Pagination? Yes

Thanks

@Sidd's team is working on this

Thanks any ETA when and what release it will be in ?

Hi @Abhijeet Kushe yes we are working on this . Can you take a look at my comment in https://github.com/apache/pinot/issues/5246 to see if your requirements are aligned or not ?

Hi Sid actually my problem was pagination does not work with distinct select queries,The reason give to me was that distinct doe not support pagination.I dont this this talks about that @Sidd