Hello all, 1] Wanted to know how to calculate the Median value for a particular column in Pinot version v1.0.1,[Not using Percentile tho , as it returns max - min value] 2] and how to find the diff() between two rows current and previous rows without using Join function.

1. Afaik, percentile is the only one. I didn't fully get what's the issue with using it? 2. You can use lag/lead window functions

Thank you so much Mayank , their is nothing issue in using percentile but wanted to know is their any other alternative function that can be used ....