Thanks for the replies. Yes I was thinking about a UDF to support this.I will look at the iotdb-quality UDF as that shows a percentile method as well as distinct.Thanks Trevor ---- On Sat, 13 Mar 2021 00:33:15 +1300 saint...@gmail.com wrote ----Hi,
Exactly percentile may be a disaster as it needs to sort all data. Therefore, we have to use some approximate algorithm. As I know, There is a UDF library [1] that will implement that. [1] https://thulab.github.io/iotdb-quality/ Best, ----------------------------------- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Jialin Qiao <qj...@mails.tsinghua.edu.cn> 于2021年3月12日周五 下午6:07写道: > Hi, > > > Is sorting by a value other than time ever going to be supported? > > This could be a new feature, you could create an issue for this feature :) > > > > Is a percentile function (eg PERCENTILE_DISC) on the road map? > > Percentile function could be implemented through UDF in 0.12.0-SNAPSHOT. > > Welcome to contribute this function as a built-in UDF in IoTDB. You could > refer to [1] > > > [1] > http://iotdb.apache.org/UserGuide/Master/Operation%20Manual/UDF%20User%20Defined%20Function.html > > Thanks, > -- > Jialin Qiao > School of Software, Tsinghua University > > 乔嘉林 > 清华大学 软件学院 > > -----原始邮件----- > *发件人:*"Trevor Hart" <tre...@ope.nz> > *发送时间:*2021-03-12 17:10:05 (星期五) > *收件人:* dev <dev@iotdb.apache.org> > *抄送:* > *主题:* Percentile? > > Hello, > > I'm trying to determine percentile values from sensor values. > > In a normal RDBM this can be achieved by sorting sensor values and then > using OFFSET and LIMIT to determine the 90th percentile etc. However in > iotDB we cant sort by sensor values > > Is sorting by a value other than time ever going to be supported? > > Is a percentile function (eg PERCENTILE_DISC) on the road map? > > Thanks > Trevor > > >