What it will happen if the raw data schema is the following : | time | root.a1.b1.c| root.a2.b2.c| root.a.b.d|
----------------------------------- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 wangyanhong (Jira) <[email protected]> 于2021年7月21日周三 下午4:26写道： > > [ > https://issues.apache.org/jira/browse/IOTDB-1512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17384736#comment-17384736 > ] > > wangyanhong commented on IOTDB-1512: > ------------------------------------ > > assume there are two timeseries root.a.b.c root.a.b.d and data as follows > > > ||time||root.a.b.c||root.a.b.d|| > |1 |2 |3| > |2|2|4| > |3|3|5| > |4|3|6| > > when execute “select last_value(d) from root.a.b group by c”，will get > ||root.a.b.c||last_value(root.a.b.d)|| > |2|4| > |3|6| > > > Add new syntax > > -------------- > > > > Key: IOTDB-1512 > > URL: https://issues.apache.org/jira/browse/IOTDB-1512 > > Project: Apache IoTDB > > Issue Type: New Feature > > Reporter: wangyanhong > > Priority: Major > > > > now，there is no sql support to group by sensor > > eg： > > select last_value(d) from root.a.b group by c > > > > -- > This message was sent by Atlassian Jira > (v8.3.4#803005) >
