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 2022/06/27 03:46:00 UTC
[jira] [Commented] (IOTDB-3381) There is an error when executing the query of the constant sequence generation function
[ https://issues.apache.org/jira/browse/IOTDB-3381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17558977#comment-17558977 ]
xiaozhihong commented on IOTDB-3381:
------------------------------------
commit e71044e1bb8bfb18cfdea7c3afeb087effaac118
I verified.
!image-2022-06-27-11-44-47-949.png|width=863,height=168!
> There is an error when executing the query of the constant sequence generation function
> ---------------------------------------------------------------------------------------
>
> Key: IOTDB-3381
> URL: https://issues.apache.org/jira/browse/IOTDB-3381
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Cluster, mpp-cluster
> Affects Versions: 0.14.0-SNAPSHOT
> Reporter: xiaozhihong
> Assignee: Steve Yurong Su
> Priority: Major
> Labels: cluster
> Attachments: image-2022-06-27-11-44-47-949.png, logs.zip
>
>
> Start 3 confignodes, 3 datanodes, execute SQL, then reported error message.
> {code:java}
> IoTDB> select s1, s2, const(s1, 'value'='1024', 'type'='INT64'), pi(s2), e(s1, s2) from root.sg.d1;
> Msg: 500: [INTERNAL_SERVER_ERROR(500)] Exception occurred: "select s1, s2, const(s1, 'value'='1024', 'type'='INT64'), pi(s2), e(s1, s2) from root.sg.d1". executeStatement failed. error code: TSStatus(code:411, message:Fragment cannot be dispatched)
> {code}
> The steps to reproduce are as follows:
> step 1 : start 3 confignodes, 3 datanodes
> step 2: enter cli, execute SQL
> {code:java}
> create storage group root.sg;
> create timeseries root.sg.d1.s1 with datatype=float,encoding=RLE;
> create timeseries root.sg.d1.s2 with datatype=double,encoding=RLE;
> create timeseries root.sg.d1.s3 with datatype=BOOLEAN,encoding=RLE;
> create timeseries root.sg.d1.s4 with datatype=TEXT,encoding=PLAIN;
> create timeseries root.sg.d1.s5 with datatype=INT32,encoding=RLE;
> create timeseries root.sg.d1.s6 with datatype=INT64,encoding=RLE;
> create timeseries root.sg.d2.s1 with datatype=INT64,encoding=RLE;{code}
> {code:java}
> insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(1,1.1,2.2,TRUE,'warn:1731',12,20);
> insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(2,2.2,3.3,FALSE,'warn:-8721',22,14);
> insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(3,2.5,2.2,TRUE,'error:-37229',14,22);
> insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(4,2.6,3.3,FALSE,'warn:1731',23,14);
> insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(5,1.1,2.2,TRUE,'warn:1731',12,20);
> insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(6,2.2,3.3,FALSE,'warn:-8721',22,14);
> insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(7,2.5,2.2,TRUE,'warn:1731',14,22);
> insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(8,2.6,3.3,FALSE,'error:-37229',23,14);
> insert into root.sg.d2(time,s1) values(1,12);
> insert into root.sg.d2(time,s1) values(2,32);
> insert into root.sg.d2(time,s1) values(1607603775000,1531604122307244742);
> insert into root.sg.d2(time,s1) values(1607603776000,-8581625725655917595); {code}
> {code:java}
> select s1, s2, const(s1, 'value'='1024', 'type'='INT64'), pi(s2), e(s1, s2) from root.sg.d1;
> {code}
> log information view attachment.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)