Hi, +1 for select last(s1), last(s2) from root.sg.d
I think this vote description does not show why we need a new syntax and the data result format we will get... For example, the first SQL is a common query statement, but why it is not suitable and you want a new syntax? It is hard to let other guys joining the vote. Best, ----------------------------------- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Dawei Liu <[email protected]> 于2020年2月21日周五 下午5:35写道： > Hi, > > I’d vote for > > [2] select last(s1), last(s2) from root.sg.d align by sensor > > It looks simple, it's easy to use, it's human logic > > > Thanks > --- > Dawei Liu > > > > > 2020年2月21日 下午5:26，Wei Shao <[email protected]> 写道： > > > > Hi, > > > > > > I'd vote for > > [4]. select last s1, s2 from root.sg.d > > > > > > Thanks, > > Wei > > > > > > > > At 2020-02-21 17:08:14, "Wei Shao" <[email protected]> wrote: > >> Hi, > >> > >> > >> We are to determine the exact syntax of Last Query for IoTDB. Last > query is to select the latest time-value pair result for a given timeseries. > >> You can choose from the following syntax options. > >> 1. select last(s1), last(s2) from root.sg.d > >> 2. select last(s1), last(s2) from root.sg.d align by sensor > >> 3. select last(s1, s2) from root.sg.d > >> 4. select last s1, s2 from root.sg.d > >> 5. last s1, s2 from root.sg.d > >> 6. select s1, s2 from root.sg.d last > >> 7. select s1, s2 from root.sg.d onlylast > >> > >> > >> Please vote for the option you are comfortable with. > >> > >> > >> Thanks, > >> Wei > >
