You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by 田原 <ti...@mails.tsinghua.edu.cn> on 2020/06/10 07:41:42 UTC
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
> -----原始邮件-----
> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> 发送时间: 2020-06-10 15:29:16 (星期三)
> 收件人: dev@iotdb.apache.org
> 抄送:
> 主题: [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
Re: I've submitted a PR for ISSUE-1281
Posted by Jialin Qiao <qj...@mails.tsinghua.edu.cn>.
Hi,
show latest timeseries looks good to me.
Thanks,
--
Jialin Qiao
School of Software, Tsinghua University
乔嘉林
清华大学 软件学院
> -----原始邮件-----
> 发件人: "孙泽嵩" <sz...@mails.tsinghua.edu.cn>
> 发送时间: 2020-06-11 09:49:16 (星期四)
> 收件人: dev@iotdb.apache.org
> 抄送:
> 主题: Re: I've submitted a PR for ISSUE-1281
>
> 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 <sa...@gmail.com> 写道：
> >
> > 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 <wx...@gmail.com> 于2020年6月10日周三 下午10:20写道：
> >
> >> Hi,
> >>
> >> +1 for "order by latest".
> >>
> >> Jialin Qiao <qj...@mails.tsinghua.edu.cn> 于2020年6月10日周三 下午8:51写道：
> >>
> >>> Hi,
> >>>
> >>> Order by latest is ok. What do you think, Huang?
> >>>
> >>> Thanks,
> >>> --
> >>> Jialin Qiao
> >>> School of Software, Tsinghua University
> >>>
> >>> 乔嘉林
> >>> 清华大学 软件学院
> >>>
> >>>> -----原始邮件-----
> >>>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> >>>> 发送时间: 2020-06-10 20:20:06 (星期三)
> >>>> 收件人: dev@iotdb.apache.org
> >>>> 抄送:
> >>>> 主题: 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
> >>>>
> >>>>
> >>>>
> >>>>> -----原始邮件-----
> >>>>> 发件人: "孙泽嵩" <sz...@mails.tsinghua.edu.cn>
> >>>>> 发送时间: 2020-06-10 18:07:09 (星期三)
> >>>>> 收件人: dev@iotdb.apache.org
> >>>>> 抄送:
> >>>>> 主题: 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 <qj...@mails.tsinghua.edu.cn> 写道：
> >>>>>>
> >>>>>> 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
> >>>>>>
> >>>>>> 乔嘉林
> >>>>>> 清华大学 软件学院
> >>>>>>
> >>>>>>> -----原始邮件-----
> >>>>>>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> >>>>>>> 发送时间: 2020-06-10 15:41:42 (星期三)
> >>>>>>> 收件人: dev@iotdb.apache.org
> >>>>>>> 抄送:
> >>>>>>> 主题: 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
> >>>>>>>
> >>>>>>>
> >>>>>>>> -----原始邮件-----
> >>>>>>>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> >>>>>>>> 发送时间: 2020-06-10 15:29:16 (星期三)
> >>>>>>>> 收件人: dev@iotdb.apache.org
> >>>>>>>> 抄送:
> >>>>>>>> 主题: [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
> >>
>
Re: I've submitted a PR for ISSUE-1281
Posted by 孙泽嵩 <sz...@mails.tsinghua.edu.cn>.
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 <sa...@gmail.com> 写道：
>
> 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 <wx...@gmail.com> 于2020年6月10日周三 下午10:20写道：
>
>> Hi,
>>
>> +1 for "order by latest".
>>
>> Jialin Qiao <qj...@mails.tsinghua.edu.cn> 于2020年6月10日周三 下午8:51写道：
>>
>>> Hi,
>>>
>>> Order by latest is ok. What do you think, Huang?
>>>
>>> Thanks,
>>> --
>>> Jialin Qiao
>>> School of Software, Tsinghua University
>>>
>>> 乔嘉林
>>> 清华大学 软件学院
>>>
>>>> -----原始邮件-----
>>>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
>>>> 发送时间: 2020-06-10 20:20:06 (星期三)
>>>> 收件人: dev@iotdb.apache.org
>>>> 抄送:
>>>> 主题: 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
>>>>
>>>>
>>>>
>>>>> -----原始邮件-----
>>>>> 发件人: "孙泽嵩" <sz...@mails.tsinghua.edu.cn>
>>>>> 发送时间: 2020-06-10 18:07:09 (星期三)
>>>>> 收件人: dev@iotdb.apache.org
>>>>> 抄送:
>>>>> 主题: 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 <qj...@mails.tsinghua.edu.cn> 写道：
>>>>>>
>>>>>> 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
>>>>>>
>>>>>> 乔嘉林
>>>>>> 清华大学 软件学院
>>>>>>
>>>>>>> -----原始邮件-----
>>>>>>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
>>>>>>> 发送时间: 2020-06-10 15:41:42 (星期三)
>>>>>>> 收件人: dev@iotdb.apache.org
>>>>>>> 抄送:
>>>>>>> 主题: 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
>>>>>>>
>>>>>>>
>>>>>>>> -----原始邮件-----
>>>>>>>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
>>>>>>>> 发送时间: 2020-06-10 15:29:16 (星期三)
>>>>>>>> 收件人: dev@iotdb.apache.org
>>>>>>>> 抄送:
>>>>>>>> 主题: [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
>>
Re: I've submitted a PR for ISSUE-1281
Posted by Xiangdong Huang <sa...@gmail.com>.
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 <wx...@gmail.com> 于2020年6月10日周三 下午10:20写道：
> Hi,
>
> +1 for "order by latest".
>
> Jialin Qiao <qj...@mails.tsinghua.edu.cn> 于2020年6月10日周三 下午8:51写道：
>
> > Hi,
> >
> > Order by latest is ok. What do you think, Huang?
> >
> > Thanks,
> > --
> > Jialin Qiao
> > School of Software, Tsinghua University
> >
> > 乔嘉林
> > 清华大学 软件学院
> >
> > > -----原始邮件-----
> > > 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> > > 发送时间: 2020-06-10 20:20:06 (星期三)
> > > 收件人: dev@iotdb.apache.org
> > > 抄送:
> > > 主题: 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
> > >
> > >
> > >
> > > > -----原始邮件-----
> > > > 发件人: "孙泽嵩" <sz...@mails.tsinghua.edu.cn>
> > > > 发送时间: 2020-06-10 18:07:09 (星期三)
> > > > 收件人: dev@iotdb.apache.org
> > > > 抄送:
> > > > 主题: 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 <qj...@mails.tsinghua.edu.cn> 写道：
> > > > >
> > > > > 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
> > > > >
> > > > > 乔嘉林
> > > > > 清华大学 软件学院
> > > > >
> > > > >> -----原始邮件-----
> > > > >> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> > > > >> 发送时间: 2020-06-10 15:41:42 (星期三)
> > > > >> 收件人: dev@iotdb.apache.org
> > > > >> 抄送:
> > > > >> 主题: 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
> > > > >>
> > > > >>
> > > > >>> -----原始邮件-----
> > > > >>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> > > > >>> 发送时间: 2020-06-10 15:29:16 (星期三)
> > > > >>> 收件人: dev@iotdb.apache.org
> > > > >>> 抄送:
> > > > >>> 主题: [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
>
Re: I've submitted a PR for ISSUE-1281
Posted by Xiangwei Wei <wx...@gmail.com>.
Hi,
+1 for "order by latest".
Jialin Qiao <qj...@mails.tsinghua.edu.cn> 于2020年6月10日周三 下午8:51写道：
> Hi,
>
> Order by latest is ok. What do you think, Huang?
>
> Thanks,
> --
> Jialin Qiao
> School of Software, Tsinghua University
>
> 乔嘉林
> 清华大学 软件学院
>
> > -----原始邮件-----
> > 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> > 发送时间: 2020-06-10 20:20:06 (星期三)
> > 收件人: dev@iotdb.apache.org
> > 抄送:
> > 主题: 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
> >
> >
> >
> > > -----原始邮件-----
> > > 发件人: "孙泽嵩" <sz...@mails.tsinghua.edu.cn>
> > > 发送时间: 2020-06-10 18:07:09 (星期三)
> > > 收件人: dev@iotdb.apache.org
> > > 抄送:
> > > 主题: 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 <qj...@mails.tsinghua.edu.cn> 写道：
> > > >
> > > > 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
> > > >
> > > > 乔嘉林
> > > > 清华大学 软件学院
> > > >
> > > >> -----原始邮件-----
> > > >> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> > > >> 发送时间: 2020-06-10 15:41:42 (星期三)
> > > >> 收件人: dev@iotdb.apache.org
> > > >> 抄送:
> > > >> 主题: 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
> > > >>
> > > >>
> > > >>> -----原始邮件-----
> > > >>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> > > >>> 发送时间: 2020-06-10 15:29:16 (星期三)
> > > >>> 收件人: dev@iotdb.apache.org
> > > >>> 抄送:
> > > >>> 主题: [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
Re: I've submitted a PR for ISSUE-1281
Posted by Jialin Qiao <qj...@mails.tsinghua.edu.cn>.
Hi,
Order by latest is ok. What do you think, Huang?
Thanks,
--
Jialin Qiao
School of Software, Tsinghua University
乔嘉林
清华大学 软件学院
> -----原始邮件-----
> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> 发送时间: 2020-06-10 20:20:06 (星期三)
> 收件人: dev@iotdb.apache.org
> 抄送:
> 主题: 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
>
>
>
> > -----原始邮件-----
> > 发件人: "孙泽嵩" <sz...@mails.tsinghua.edu.cn>
> > 发送时间: 2020-06-10 18:07:09 (星期三)
> > 收件人: dev@iotdb.apache.org
> > 抄送:
> > 主题: 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 <qj...@mails.tsinghua.edu.cn> 写道：
> > >
> > > 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
> > >
> > > 乔嘉林
> > > 清华大学 软件学院
> > >
> > >> -----原始邮件-----
> > >> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> > >> 发送时间: 2020-06-10 15:41:42 (星期三)
> > >> 收件人: dev@iotdb.apache.org
> > >> 抄送:
> > >> 主题: 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
> > >>
> > >>
> > >>> -----原始邮件-----
> > >>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> > >>> 发送时间: 2020-06-10 15:29:16 (星期三)
> > >>> 收件人: dev@iotdb.apache.org
> > >>> 抄送:
> > >>> 主题: [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
> >
Re: Re: I've submitted a PR for ISSUE-1281
Posted by 田原 <ti...@mails.tsinghua.edu.cn>.
Hi,
I also think 'order by latest' is better.
What do you think, Qiao?
Best,
---------------
Yuan Tian
> -----原始邮件-----
> 发件人: "孙泽嵩" <sz...@mails.tsinghua.edu.cn>
> 发送时间: 2020-06-10 18:07:09 (星期三)
> 收件人: dev@iotdb.apache.org
> 抄送:
> 主题: 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 <qj...@mails.tsinghua.edu.cn> 写道：
> >
> > 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
> >
> > 乔嘉林
> > 清华大学 软件学院
> >
> >> -----原始邮件-----
> >> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> >> 发送时间: 2020-06-10 15:41:42 (星期三)
> >> 收件人: dev@iotdb.apache.org
> >> 抄送:
> >> 主题: 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
> >>
> >>
> >>> -----原始邮件-----
> >>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> >>> 发送时间: 2020-06-10 15:29:16 (星期三)
> >>> 收件人: dev@iotdb.apache.org
> >>> 抄送:
> >>> 主题: [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
>
Re: I've submitted a PR for ISSUE-1281
Posted by 孙泽嵩 <sz...@mails.tsinghua.edu.cn>.
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 <qj...@mails.tsinghua.edu.cn> 写道：
>
> 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
>
> 乔嘉林
> 清华大学 软件学院
>
>> -----原始邮件-----
>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
>> 发送时间: 2020-06-10 15:41:42 (星期三)
>> 收件人: dev@iotdb.apache.org
>> 抄送:
>> 主题: 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
>>
>>
>>> -----原始邮件-----
>>> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
>>> 发送时间: 2020-06-10 15:29:16 (星期三)
>>> 收件人: dev@iotdb.apache.org
>>> 抄送:
>>> 主题: [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
Re: I've submitted a PR for ISSUE-1281
Posted by Jialin Qiao <qj...@mails.tsinghua.edu.cn>.
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
乔嘉林
清华大学 软件学院
> -----原始邮件-----
> 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> 发送时间: 2020-06-10 15:41:42 (星期三)
> 收件人: dev@iotdb.apache.org
> 抄送:
> 主题: 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
>
>
> > -----原始邮件-----
> > 发件人: "田原" <ti...@mails.tsinghua.edu.cn>
> > 发送时间: 2020-06-10 15:29:16 (星期三)
> > 收件人: dev@iotdb.apache.org
> > 抄送:
> > 主题: [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