Uploaded image for project: 'Apache IoTDB'
  1. Apache IoTDB
  2. IOTDB-5861

Last quey is incomplete

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • master
    • None
    • Core/Query
    • None

    Description

      Branch : master

      commit a52beb4e996e773fe7a4e9329f93765c48310807

      Start 1C1D, execute last query is incomplete.

      create aligned timeseries root.ln_1.tb_6141(风机退出_BOOLEAN BOOLEAN encoding=RLE,`出水NH4-N_DOUBLE` DOUBLE encoding=GORILLA,膜产水状态_BOOLEAN BOOLEAN encoding=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,`开关量-运行_BOOLEAN` BOOLEAN encoding=RLE,功能码_DOUBLE DOUBLE encoding=GORILLA);
alter timeseries root.ln_1.tb_6141.风机退出_BOOLEAN upsert alias=风机退出;
alter timeseries root.ln_1.tb_6141.水管流速_DOUBLE upsert alias=水管流速;
alter timeseries root.ln_1.tb_6141.CO2_DOUBLE upsert alias=CO2;
alter timeseries root.ln_1.tb_6141.风机投入_BOOLEAN upsert alias=风机投入;
alter timeseries root.ln_1.tb_6141.产水间歇运行时间设置_DOUBLE upsert alias=产水间歇运行时间设置;
alter timeseries root.ln_1.tb_6141.膜产水状态_BOOLEAN upsert alias=膜产水状态;
alter timeseries root.ln_1.tb_6141.枚举_INT32 upsert alias=枚举;
alter timeseries root.ln_1.tb_6141.出水TP_DOUBLE upsert alias=出水TP;
alter timeseries root.ln_1.tb_6141.文本_TEXT upsert alias=文本;
alter timeseries root.ln_1.tb_6141.`出水NH4-N_DOUBLE` upsert alias=`出水NH4-N`;
alter timeseries root.ln_1.tb_6141.功能码_DOUBLE upsert alias=功能码;
alter timeseries root.ln_1.tb_6141.11_TEXT upsert alias=`11`;
alter timeseries root.ln_1.tb_6141.`开关量-运行_BOOLEAN` upsert alias=`开关量-运行`;

show timeseries root.ln_1.tb_6141.*;
insert into root.ln_1.tb_6141(time,产水间歇运行时间设置_DOUBLE) aligned values(1679365910000,10.0);
insert into root.ln_1.tb_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);

select last * from root.ln_1.tb_6141;
select last 功能码,文本 from root.ln_1.tb_6141;
select last 功能码,膜产水状态,文本 from root.ln_1.tb_6141;
select last 膜产水状态,文本 from root.ln_1.tb_6141;
select last 功能码,膜产水状态 from root.ln_1.tb_6141;
select last 功能码_DOUBLE,膜产水状态_BOOLEAN from root.ln_1.tb_6141;
select last 功能码,膜产水状态,出水NH4-N from root.ln_1.tb_6141;
<<SQLSTATE;
select last 功能码,`出水NH4-N` from root.ln_1.tb_6141; 
      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

      Attachments

        Activity

          People

            liaolanyu liaolanyu
            xiaozhihong xiaozhihong
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: