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

Failed to insert into the alias series on the first attempt, succeeded on the second attempt

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.2
    • None
    • Core/Server, mpp-cluster

    Description

      问题描述:向别名序列insert,相同的SQL,第一次执行报错,第2次执行成功。
      测试版本:iotdb_master_0531_fc2746e]

      drop database root.1Y ;
      drop database root.0Y ;
      create database root.1Y ;
      create database root.0Y ;
      create ALIGNED timeseries root.1Y.2MO(1Y DOUBLE compressor=SNAPPY,2MO DOUBLE ENCODING=RLE compressor=LZ4,3W DOUBLE ENCODING=TS_2DIFF compressor=GZIP,4D DOUBLE ENCODING=GORILLA compressor=ZSTD,5H DOUBLE ENCODING=FREQ compressor=LZMA2,6M DOUBLE ENCODING=CHIMP compressor=UNCOMPRESSED,7S DOUBLE ENCODING=SPRINTZ compressor=LZ4,8MS DOUBLE ENCODING=RLBE compressor=GZIP,9US DOUBLE compressor=ZSTD,10NS DOUBLE compressor=LZMA2,11ns DOUBLE compressor=SNAPPY,12us DOUBLE compressor=UNCOMPRESSED) ;
      insert into root.1Y.2MO(time,1Y) ALIGNED values(1,1.1);
      insert into root.1Y.2MO(time,2MO) ALIGNED values(1,1.1);
      insert into root.1Y.2MO(time,3W) ALIGNED values(2,2.1);
      insert into root.1Y.2MO(time,4D) ALIGNED values(2,2.1);
      insert into root.1Y.2MO(time,5H) ALIGNED values(3,3.1);
      insert into root.1Y.2MO(time,6M) ALIGNED values(3,3.1);
      insert into root.1Y.2MO(time,7S) ALIGNED values(4,4.1);
      insert into root.1Y.2MO(time,8MS) ALIGNED values(4,4.1);
      insert into root.1Y.2MO(time,9US) ALIGNED values(5,5.1);
      insert into root.1Y.2MO(time,10NS) ALIGNED values(5,5.1);
      insert into root.1Y.2MO(time,11ns) ALIGNED values(6,6.1);
      insert into root.1Y.2MO(time,12us) ALIGNED values(6,6.1);
      select * from root.1Y.2MO;
      flush;
      select * from root.1Y.2MO;
      create view root.0Y.2MO(1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us ) as root.1Y.2MO(1Y,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us );
      select 1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us from root.1Y.*,root.0Y.*;
      下面的2条sql在cli 串行执行。
      IoTDB> insert into root.0Y.2MO(time,1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us) aligned values(2,2.2,2.3,2.4,2.5,2.6,2.7,2.8,2.9,21.1,22.2,22.3,22.4);
      Msg: 609: timeseries under this device are not aligned, please use non-aligned interface (Path: root.0Y.2MO)
      IoTDB>
      IoTDB> insert into root.0Y.2MO(time,1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us) aligned values(2,2.2,2.3,2.4,2.5,2.6,2.7,2.8,2.9,21.1,22.2,22.3,22.4);
      Msg: The statement is executed successfully.
      insert into root.0Y.2MO(time,1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us) aligned values(2,2.2,2.3,2.4,2.5,2.6,2.7,2.8,2.9,21.1,22.2,22.3,22.4);
      insert into root.0Y.2MO(time,1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us) aligned values(2,2.2,2.3,2.4,2.5,2.6,2.7,2.8,2.9,21.1,22.2,22.3,22.4);

      Attachments

        Activity

          People

            citrusreticulata Xingyu Liu
            刘珍 刘珍
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: