You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Haonan Hou (Jira)" <ji...@apache.org> on 2021/01/26 14:25:00 UTC
[jira] [Commented] (IOTDB-1124) SHOW LATEST TIMESERIES显示顺序不正确
[ https://issues.apache.org/jira/browse/IOTDB-1124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17272120#comment-17272120 ]
Haonan Hou commented on IOTDB-1124:
-----------------------------------
* SHOW LATEST TIMESERIES
表示查询出的时间序列需要按照最近插入时间戳降序排列
需要注意的是,当查询路径不存在时,系统会返回0条时间序列。
这里按照是按照insert data的时间戳进行排序,不是按照create timeseries的先后顺序。
> SHOW LATEST TIMESERIES显示顺序不正确
> -----------------------------
>
> Key: IOTDB-1124
> URL: https://issues.apache.org/jira/browse/IOTDB-1124
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Server
> Environment: version 0.11.3-SNAPSHOT
> Reporter: 刘珍
> Priority: Minor
> Attachments: image-2021-01-25-16-22-14-827.png, image-2021-01-25-16-22-52-738.png
>
>
> 复现流程:
> cli连接IoTDB每次执行1条SQL:
> create timeseries root.db_1.tab1.status with datatype=BOOLEAN,encoding=PLAIN ;
> create timeseries root.db_1.tab2.temperature with datatype=FLOAT,encoding=PLAIN ;
> create timeseries root.db_1.tab3.hardware with datatype=TEXT,encoding=PLAIN ;
> create timeseries root.db_1.tab4.price with datatype=DOUBLE,encoding=PLAIN ;
> create timeseries root.db_1.tab5.age with datatype=INT32,encoding=REGULAR ;
> create timeseries root.db_1.tab6.salary with datatype=INT64,encoding=REGULAR ;
> SHOW LATEST TIMESERIES;
> 结果为:
>
> 最近插入时间戳在结果集下面,有序。
> !image-2021-01-25-16-22-52-738.png!
> 再执行
> create timeseries root.db_2.tab0.salary with datatype=INT64,encoding=REGULAR ;
> SHOW LATEST TIMESERIES; --查询结果有序
> create timeseries root.db_0.tab0.salary with datatype=INT64,encoding=REGULAR ;
> SHOW LATEST TIMESERIES;
> !image-2021-01-25-16-22-14-827.png!
> 最近插入的时间戳在结果集的第一行,乱序。
--
This message was sent by Atlassian Jira
(v8.3.4#803005)