You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "xiaozhihong (Jira)" <ji...@apache.org> on 2023/05/10 10:25:00 UTC
[jira] [Created] (IOTDB-5861) Last quey is incomplete
xiaozhihong created IOTDB-5861:
----------------------------------
Summary: Last quey is incomplete
Key: IOTDB-5861
URL: https://issues.apache.org/jira/browse/IOTDB-5861
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Query
Affects Versions: master
Reporter: xiaozhihong
Assignee: liaolanyu
Attachments: image-2023-05-10-18-24-09-245.png
Branch : master
commit a52beb4e996e773fe7a4e9329f93765c48310807
Start 1C1D, execute last query is incomplete.
{code:java}
IoTDB> create aligned timeseries root.ln_1.tb_6141(风机退出_BOOLEAN BOOLEAN encoding=RLE,`出水NH4-N_DOUBLE` DOUBLE encoding=GORILLA,膜产水状态_BOOLEAN BOOLEAN en
coding=RLE,11_TEXT TEXT encoding=PLAIN,产水间歇运行时间设置_DOUBLE DOUBLE encoding=GORILLA,文本_TEXT TEXT encoding=PLAIN, 风机投入_BOOLEAN BOOLEAN encoding=RLE,
枚举_INT32 INT32 encoding=RLE,出水TP_DOUBLE DOUBLE encoding=GORILLA,水管流速_DOUBLE DOUBLE encoding=GORILLA,CO2_DOUBLE DOUBLE encoding=GORILLA,`开关量-运行_BOOLE
AN` BOOLEAN encoding=RLE,功能码_DOUBLE DOUBLE encoding=GORILLA);
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.风机退出_BOOLEAN upsert alias=风机退出;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.水管流速_DOUBLE upsert alias=水管流速;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.CO2_DOUBLE upsert alias=CO2;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.风机投入_BOOLEAN upsert alias=风机投入;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.产水间歇运行时间设置_DOUBLE upsert alias=产水间歇运行时间设置;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.膜产水状态_BOOLEAN upsert alias=膜产水状态;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.枚举_INT32 upsert alias=枚举;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.出水TP_DOUBLE upsert alias=出水TP;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.文本_TEXT upsert alias=文本;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.`出水NH4-N_DOUBLE` upsert alias=`出水NH4-N`;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.功能码_DOUBLE upsert alias=功能码;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.11_TEXT upsert alias=`11`;
Msg: The statement is executed successfully.
IoTDB> alter timeseries root.ln_1.tb_6141.`开关量-运行_BOOLEAN` upsert alias=`开关量-运行`;
Msg: The statement is executed successfully.
IoTDB> show timeseries;
+---------------------------------------------+--------------------+---------+--------+--------+-----------+----+----------+--------+------------------+--------+
| Timeseries| Alias| Database|DataType|Encoding|Compression|Tags|Attributes|Deadband|DeadbandParameters|ViewType|
+---------------------------------------------+--------------------+---------+--------+--------+-----------+----+----------+--------+------------------+--------+
| root.ln_1.tb_6141.水管流速_DOUBLE| 水管流速|root.ln_1| DOUBLE| GORILLA| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.风机退出_BOOLEAN| 风机退出|root.ln_1| BOOLEAN| RLE| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.CO2_DOUBLE| CO2|root.ln_1| DOUBLE| GORILLA| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.风机投入_BOOLEAN| 风机投入|root.ln_1| BOOLEAN| RLE| SNAPPY|null| null| null| null| |
|root.ln_1.tb_6141.产水间歇运行时间设置_DOUBLE|产水间歇运行时间设置|root.ln_1| DOUBLE| GORILLA| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.膜产水状态_BOOLEAN| 膜产水状态|root.ln_1| BOOLEAN| RLE| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.枚举_INT32| 枚举|root.ln_1| INT32| RLE| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.出水TP_DOUBLE| 出水TP|root.ln_1| DOUBLE| GORILLA| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.文本_TEXT| 文本|root.ln_1| TEXT| PLAIN| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.`出水NH4-N_DOUBLE`| `出水NH4-N`|root.ln_1| DOUBLE| GORILLA| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.功能码_DOUBLE| 功能码|root.ln_1| DOUBLE| GORILLA| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.11_TEXT| `11`|root.ln_1| TEXT| PLAIN| SNAPPY|null| null| null| null| |
| root.ln_1.tb_6141.`开关量-运行_BOOLEAN`| `开关量-运行`|root.ln_1| BOOLEAN| RLE| SNAPPY|null| null| null| null| |
+---------------------------------------------+--------------------+---------+--------+--------+-----------+----+----------+--------+------------------+--------+
Total line number = 13
It costs 0.012s
IoTDB> insert into root.ln_1.tb_6141(time,产水间歇运行时间设置_DOUBLE) aligned values(1679365910000,10.0);
_6141(time,出水TP_DOUBLE) aligned values(1679365910000,15.0);
insert into root.ln_1.tb_6141(time,功能码_DOUBLE) aligned values(1679477545000,2.0);
insert into root.ln_1.tb_6141(time,文本_TEXT) aligned values(1675995566000,52);
insert into root.ln_1.tb_6141(time,枚举_INT32) aligned values(1675995566000,2);
insert into root.ln_1.tb_6141(time,水管流速_DOUBLE) aligned values(1679365910000,15.0);
insert into root.ln_1.tb_6141(time,膜产水状态_BOOLEAN) aligned values(1677033625000,true);
insert into root.ln_1.tb_6141(time,风机投入_BOOLEAN) aligned values(1675995566000,true);
insert into root.ln_1.tb_6141(time,风机退出_BOOLEAN) aligned values(1675995566000,false);
insert into root.ln_1.tb_6141(time,11_TEXT) aligned values(1679365910000,13);
insert into root.ln_1.tb_6141(time,CO2_DOUBLE) aligned values(1679365910000,12.0);
insert into root.ln_1.tb_6141(time,`出水NH4-N_DOUBLE`) aligned values(1679365910000,12.0);
insert into root.ln_1.tb_6141(time,`开关量-运行_BOOLEAN`) aligned values(1675995566000,false);Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,出水TP_DOUBLE) aligned values(1679365910000,15.0);
Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,功能码_DOUBLE) aligned values(1679477545000,2.0);
Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,文本_TEXT) aligned values(1675995566000,52);Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,枚举_INT32) aligned values(1675995566000,2);
Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,水管流速_DOUBLE) aligned values(1679365910000,15.0);
Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,膜产水状态_BOOLEAN) aligned values(1677033625000,true);
Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,风机投入_BOOLEAN) aligned values(1675995566000,true);
Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,风机退出_BOOLEAN) aligned values(1675995566000,false);
Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,11_TEXT) aligned values(1679365910000,13);
Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,CO2_DOUBLE) aligned values(1679365910000,12.0);
Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,`出水NH4-N_DOUBLE`) aligned values(1679365910000,12.0);
Msg: The statement is executed successfully.
IoTDB> insert into root.ln_1.tb_6141(time,`开关量-运行_BOOLEAN`) aligned values(1675995566000,false);
Msg: The statement is executed successfully.
IoTDB> select last * from root.ln_1.tb_6141;
+-----------------------------+---------------------------------------------+-----+--------+
| Time| Timeseries|Value|DataType|
+-----------------------------+---------------------------------------------+-----+--------+
|2023-03-21T10:31:50.000+08:00|root.ln_1.tb_6141.产水间歇运行时间设置_DOUBLE| 10.0| DOUBLE|
|2023-03-21T10:31:50.000+08:00| root.ln_1.tb_6141.出水TP_DOUBLE| 15.0| DOUBLE|
|2023-03-22T17:32:25.000+08:00| root.ln_1.tb_6141.功能码_DOUBLE| 2.0| DOUBLE|
|2023-02-10T10:19:26.000+08:00| root.ln_1.tb_6141.文本_TEXT| 52| TEXT|
|2023-02-10T10:19:26.000+08:00| root.ln_1.tb_6141.枚举_INT32| 2| INT32|
|2023-03-21T10:31:50.000+08:00| root.ln_1.tb_6141.水管流速_DOUBLE| 15.0| DOUBLE|
|2023-02-22T10:40:25.000+08:00| root.ln_1.tb_6141.膜产水状态_BOOLEAN| true| BOOLEAN|
|2023-02-10T10:19:26.000+08:00| root.ln_1.tb_6141.风机投入_BOOLEAN| true| BOOLEAN|
|2023-02-10T10:19:26.000+08:00| root.ln_1.tb_6141.风机退出_BOOLEAN|false| BOOLEAN|
|2023-03-21T10:31:50.000+08:00| root.ln_1.tb_6141.11_TEXT| 13| TEXT|
|2023-03-21T10:31:50.000+08:00| root.ln_1.tb_6141.CO2_DOUBLE| 12.0| DOUBLE|
|2023-03-21T10:31:50.000+08:00| root.ln_1.tb_6141.`出水NH4-N_DOUBLE`| 12.0| DOUBLE|
|2023-02-10T10:19:26.000+08:00| root.ln_1.tb_6141.`开关量-运行_BOOLEAN`|false| BOOLEAN|
+-----------------------------+---------------------------------------------+-----+--------+
Total line number = 13
It costs 0.006s
IoTDB> select last 功能码,文本 from root.ln_1.tb_6141;
+-----------------------------+-------------------------------+-----+--------+
| Time| Timeseries|Value|DataType|
+-----------------------------+-------------------------------+-----+--------+
|2023-03-22T17:32:25.000+08:00|root.ln_1.tb_6141.功能码_DOUBLE| 2.0| DOUBLE|
|2023-02-10T10:19:26.000+08:00| root.ln_1.tb_6141.文本_TEXT| 52| TEXT|
+-----------------------------+-------------------------------+-----+--------+
Total line number = 2
It costs 0.010s
IoTDB> select last 功能码,膜产水状态,文本 from root.ln_1.tb_6141;
+-----------------------------+------------------------------------+-----+--------+
| Time| Timeseries|Value|DataType|
+-----------------------------+------------------------------------+-----+--------+
|2023-03-22T17:32:25.000+08:00| root.ln_1.tb_6141.功能码_DOUBLE| 2.0| DOUBLE|
|2023-02-10T10:19:26.000+08:00| root.ln_1.tb_6141.文本_TEXT| 52| TEXT|
|2023-02-22T10:40:25.000+08:00|root.ln_1.tb_6141.膜产水状态_BOOLEAN| true| BOOLEAN|
+-----------------------------+------------------------------------+-----+--------+
Total line number = 3
It costs 0.010s
IoTDB> select last 功能码,`出水NH4-N` from root.ln_1.tb_6141;
+-----------------------------+-------------------------------+-----+--------+
| Time| Timeseries|Value|DataType|
+-----------------------------+-------------------------------+-----+--------+
|2023-03-22T17:32:25.000+08:00|root.ln_1.tb_6141.功能码_DOUBLE| 2.0| DOUBLE|
+-----------------------------+-------------------------------+-----+--------+
Total line number = 1
It costs 0.007s
IoTDB> select last `出水NH4-N` from root.ln_1.tb_6141;
+-----------------------------+------------------------------------+-----+--------+
| Time| Timeseries|Value|DataType|
+-----------------------------+------------------------------------+-----+--------+
|2023-03-21T10:31:50.000+08:00|root.ln_1.tb_6141.`出水NH4-N_DOUBLE`| 12.0| DOUBLE|
+-----------------------------+------------------------------------+-----+--------+
Total line number = 1
It costs 0.005s {code}
!image-2023-05-10-18-24-09-245.png|width=537,height=171!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)