does pinot support window functions like presto? https://prestodb.io/docs/current/functions/window.html

Not yet, could you file an issue describing the use case?

ok sure.. will do

No, we don't support window functions. You can achieve that using presto -pinot connector

I understand using presto connector for join tables.. if pinot supports all single table functions (window ) then it will be helpful. our use case: To find avg response time for support tickets . We use lag window functions over audit data . If we use presto connector then large amount of data will be transferred to presto nodes and will increase query time as well.

if you partition the data on ticketid and use partition based assignment, you can achieve this in Pinot via UDF. we did this for distinct count and it showed amazing improvement in performance @User ^^

Any document reference for data partitioning techniques ? Partitioning data on ticketid will definitely help query performance.

Here are the doc for the partition based segment assignment: https://docs.pinot.apache.org/operators/operating-pinot/segment-assignment#partitioned-replica-group-segment-assignment