You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "yusicheng (Jira)" <ji...@apache.org> on 2021/08/21 02:29:00 UTC
[jira] [Created] (IOTDB-1580) sort by time error when enable time
partition
yusicheng created IOTDB-1580:
--------------------------------
Summary: sort by time error when enable time partition
Key: IOTDB-1580
URL: https://issues.apache.org/jira/browse/IOTDB-1580
Project: Apache IoTDB
Issue Type: Bug
Affects Versions: master branch
Reporter: yusicheng
step1. change IoTDBConfig parameter
{code:java}
enablePartition = false -> enablePartition = true
partitionInterval = 604800 -> partitionINterval = 2592000
{code}
step2. execute following sql
{code:sql}
set storage group to root.group_1
create timeseries root.group_1.d_1.s_0 with datatype = boolean
create timeseries root.group_1.d_1.s_1 with datatype = INT32
create timeseries root.group_1.d_1.s_2 with datatype = float
insert into root.group_1.d_1(timestamp, s_1, s_0, s_2) values(2018-07-18T00:00:00.000+08:00, 18, false, 18.18)
flush
insert into root.group_1.d_1(timestamp, s_1, s_0, s_2) values(2018-07-19T00:00:00.000+08:00, 19, false, 19.18)
flush
insert into root.group_1.d_1(timestamp, s_1, s_0, s_2) values(2019-07-19T00:00:00.000+08:00, 2019, false, 19.18)
insert into root.group_1.d_1(timestamp, s_1, s_0, s_2) values(2019-08-19T00:00:00.000+08:00, 2018, false, 19.18)
select * from root.group_1.d_1 order by time desc
{code}
step3. we can find that the result looks like this
+-----------------------------+--------------------+--------------------+--------------------+
| Time|root.group_1.d_1.s_1|root.group_1.d_1.s_0|root.group_1.d_1.s_2|
+-----------------------------+--------------------+--------------------+--------------------+
|2018-07-19T00:00:00.000+08:00| 19| false| 19.18|
|2018-07-18T00:00:00.000+08:00| 18| false| 18.18|
|2019-08-19T00:00:00.000+08:00| 2018| false| 19.18|
|2019-07-19T00:00:00.000+08:00| 2019| false| 19.18|
+-----------------------------+--------------------+--------------------+--------------------+
obviously, the result is not sorted by time desc
--
This message was sent by Atlassian Jira
(v8.3.4#803005)