Hi Team -- is there a way to run rank function on ...
# generala
Ambika
05/08/2021, 12:54 AMHi Team -- is there a way to run rank function on top of the data in pinot ?
m
Mayank
05/08/2021, 1:04 AM
Not natively in Pinot, may be presto?
a
Ambika
05/08/2021, 1:16 AMok i will try that...
m
Mayank
05/08/2021, 1:18 AM
We do have support for adding post aggregation functions, so should be a be able to add in Pinot I think
a
Ambika
05/08/2021, 1:21 AMok..
Ambika
05/08/2021, 1:23 AMi am thinking how to model a use case where every row might have multiple versions pushed out from kafka over a period of time and If I only wanted the latest version to get pulled in the aggregation , how t get that...
m
Mayank
05/08/2021, 1:26 AM
Use upsert instead?
a
Ambika
05/08/2021, 1:29 AMyeah i was thinking about it.. but was not sure if its recommended .. Have you guys tried it at prod scale?
m
Mayank
05/08/2021, 1:30 AM
Yes Uber is using it in production
a
Ambika
05/08/2021, 1:30 AMok.. Thats really good to know.. I will model something and test it this week and reach out if I get into any trouble 🙂 Thanks as always.