Hi, > Can "latest" be a noun? Yes, it could indicate the most recent development. For example, "have you heard about the latest?"
> How about `show latest timeseries` or `show timeseries order by latest > data`? Now I think `show latest timeseries` is better … : ) Best, ----------------------------------- Zesong Sun School of Software, Tsinghua University 孙泽嵩 清华大学 软件学院 > 2020年6月11日 09:36，Xiangdong Huang <[email protected]> 写道： > > Hi, > Can "latest" be a noun? > How about `show latest timeseries` or `show timeseries order by latest > data`? > Best, > ----------------------------------- > Xiangdong Huang > School of Software, Tsinghua University > > 黄向东 > 清华大学 软件学院 > > > Xiangwei Wei <[email protected]> 于2020年6月10日周三 下午10:20写道： > >> Hi, >> >> +1 for "order by latest". >> >> Jialin Qiao <[email protected]> 于2020年6月10日周三 下午8:51写道： >> >>> Hi, >>> >>> Order by latest is ok. What do you think, Huang? >>> >>> Thanks, >>> -- >>> Jialin Qiao >>> School of Software, Tsinghua University >>> >>> 乔嘉林 >>> 清华大学 软件学院 >>> >>>> -----原始邮件----- >>>> 发件人: "田原" <[email protected]> >>>> 发送时间: 2020-06-10 20:20:06 (星期三) >>>> 收件人: [email protected] >>>> 抄送: >>>> 主题: Re: Re: I've submitted a PR for ISSUE-1281 >>>> >>>> Hi, >>>> >>>> I also think 'order by latest' is better. >>>> What do you think, Qiao? >>>> >>>> Best, >>>> --------------- >>>> Yuan Tian >>>> >>>> >>>> >>>>> -----原始邮件----- >>>>> 发件人: "孙泽嵩" <[email protected]> >>>>> 发送时间: 2020-06-10 18:07:09 (星期三) >>>>> 收件人: [email protected] >>>>> 抄送: >>>>> 主题: Re: I've submitted a PR for ISSUE-1281 >>>>> >>>>> Hi Jialin, >>>>> >>>>>> I come up a scenario: If a series receives a point of last year >> now, >>> is the series hot? >>>>> Good scenario. >>>>> >>>>> How about “order by latest” ? Since “LAST” is related to another >>> function … >>>>> >>>>> Best, >>>>> ----------------------------------- >>>>> Zesong Sun >>>>> School of Software, Tsinghua University >>>>> >>>>> 孙泽嵩 >>>>> 清华大学 软件学院 >>>>> >>>>>> 2020年6月10日 16:38，Jialin Qiao <[email protected]> 写道： >>>>>> >>>>>> Hi >>>>>> >>>>>> To show timeseries and display them by the descending order of the >>> timestamp of the last point. >>>>>> >>>>>> The new grammar is designed as "order by heat". >>>>>> E.g., the last time of s1 is 10, the last time of s2 is 8. When >>> order by heat, the result will display as "s1, s2". >>>>>> >>>>>> I come up a scenario: If a series receives a point of last year >> now, >>> is the series hot? >>>>>> >>>>>> Or "order by last" ? >>>>>> >>>>>> Thanks, >>>>>> -- >>>>>> Jialin Qiao >>>>>> School of Software, Tsinghua University >>>>>> >>>>>> 乔嘉林 >>>>>> 清华大学 软件学院 >>>>>> >>>>>>> -----原始邮件----- >>>>>>> 发件人: "田原" <[email protected]> >>>>>>> 发送时间: 2020-06-10 15:41:42 (星期三) >>>>>>> 收件人: [email protected] >>>>>>> 抄送: >>>>>>> 主题: I've submitted a PR for ISSUE-1281 >>>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> I submitted a pr to add an order-by-heat feature in show time >>> series syntax. >>>>>>> >>>>>>> >>>>>>> PR: >>> https://github.com/apache/incubator-iotdb/pull/1341 >>>>>>> >>>>>>> ISSUE-1281: >>> https://github.com/apache/incubator-iotdb/issues/1281 >>>>>>> >>>>>>> >>>>>>> Best, >>>>>>> --------------- >>>>>>> Yuan Tian >>>>>>> >>>>>>> >>>>>>>> -----原始邮件----- >>>>>>>> 发件人: "田原" <[email protected]> >>>>>>>> 发送时间: 2020-06-10 15:29:16 (星期三) >>>>>>>> 收件人: [email protected] >>>>>>>> 抄送: >>>>>>>> 主题: [ISSUE-1281] Show timeseries in descending ordered of last >>> point time >>>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> >>>>>>>> I'm working on the issue-1281( >>> https://github.com/apache/incubator-iotdb/issues/1281). I plan to add a >>> sub clause in show timeseries syntax, like: >>>>>>>> >>>>>>>> >>>>>>>> SHOW TIMESERIES prefixPath? showWhereClause? orderByHeatClause? >>> limitClause? >>>>>>>> >>>>>>>> >>>>>>>> The 'orderByHeatClause' is added to support this feature. The >>> detailed syntax is: >>>>>>>> >>>>>>>> >>>>>>>> orderByHeatClause >>>>>>>> : ORDER BY HEAT >>>>>>>> ; >>>>>>>> >>>>>>>> >>>>>>>> It's an optional clause, if user doesn't specify it. The action >> of >>> 'show timeseries' will just be like before, the result set is sorted by >> the >>> registered time of the time series. >>>>>>>> >>>>>>>> >>>>>>>> If it is specified, firstly we will obtain all the satisfying >>> timeseries as before, then we will sort them by the last point's >> timestamp. >>> That means if the timeseries is inserted recently, it will be shown in >> the >>> front. >>>>>>>> >>>>>>>> >>>>>>>> In the implementation, as we have got the LeafMNode before, so we >>> can use the cachedLastValuePair field in it to get last timestamp, if the >>> cachedLastValuePair is null, we will construct a LastQueryPlan to get it. >>>>>>>> >>>>>>>> >>>>>>>> Best, >>>>>>>> --------------- >>>>>>>> Yuan Tian >>>>> >>> >> >> >> -- >> Best, >> Xiangwei Wei >>
