You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "刘珍 (Jira)" <ji...@apache.org> on 2023/05/31 08:50:00 UTC
[jira] [Created] (IOTDB-5957) Failed to insert into the alias series on the first attempt, succeeded on the second attempt
刘珍 created IOTDB-5957:
-------------------------
Summary: Failed to insert into the alias series on the first attempt, succeeded on the second attempt
Key: IOTDB-5957
URL: https://issues.apache.org/jira/browse/IOTDB-5957
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Server, mpp-cluster
Affects Versions: 1.2
Reporter: 刘珍
Assignee: Xingyu Liu
Attachments: image-2023-05-31-16-47-58-799.png
问题描述:向别名序列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 串行执行。
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);
!image-2023-05-31-16-47-58-799.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)