Hi, I have a time series data store in MapR DB JSON tables. Using drill to query data out of it. I need find 90th and 95 percentile values on the data that is there. Time series data is that of multiple sensors data per time.
I was able to get min, max and avg values by doing select `time`, min(`sensor1`), max(`sensor`), avg(`sensor1`) from dfs.`maprdb` group by `timestamp` order by `timestamp`. I need to if there is a way to specify a percentile value to calculate in query. -- Thanks and Regards, Manoj Srivatsav