Hi Trevor, Yes, but as I know, the function list is their plan. The distinct and percentile are not implemented now. Now, either implement it using UDF, or we can pay some attention to the update status of the library...
Best, ----------------------------------- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Trevor Hart <tre...@ope.nz> 于2021年3月13日周六 上午6:24写道： > 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 > > > > > > >
