You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "FengQingxin (Jira)" <ji...@apache.org> on 2022/01/13 07:41:00 UTC
[jira] [Created] (IOTDB-2383) [SQL]
FengQingxin created IOTDB-2383:
----------------------------------
Summary: [SQL]
Key: IOTDB-2383
URL: https://issues.apache.org/jira/browse/IOTDB-2383
Project: Apache IoTDB
Issue Type: Wish
Components: Client/CLI
Affects Versions: 0.13.0-SNAPSHOT
Reporter: FengQingxin
Assignee: Minghui Liu
Attachments: image-2022-01-13-15-40-13-492.png
create schema template temp1(s_0 BOOLEAN encoding=PLAIN compression=SNAPPY,s_1 BOOLEAN encoding=PLAIN compression=SNAPPY,s_2 BOOLEAN encoding=PLAIN compression=SNAPPY,s_3 BOOLEAN encoding=PLAIN compression=SNAPPY,s_4 BOOLEAN encoding=PLAIN compression=SNAPPY,s_20 DOUBLE encoding=PLAIN compression=SNAPPY,s_21 DOUBLE encoding=PLAIN compression=SNAPPY,s_22 DOUBLE encoding=PLAIN compression=SNAPPY,s_23 DOUBLE encoding=PLAIN compression=SNAPPY,s_24 DOUBLE encoding=PLAIN compression=SNAPPY,s_10 INT64 encoding=PLAIN compression=SNAPPY,s_11 INT64 encoding=PLAIN compression=SNAPPY,s_12 INT64 encoding=PLAIN compression=SNAPPY,s_13 INT64 encoding=PLAIN compression=SNAPPY,s_14 INT64 encoding=PLAIN compression=SNAPPY,s_5 INT32 encoding=PLAIN compression=SNAPPY,s_6 INT32 encoding=PLAIN compression=SNAPPY,s_7 INT32 encoding=PLAIN compression=SNAPPY,s_8 INT32 encoding=PLAIN compression=SNAPPY,s_9 INT32 encoding=PLAIN compression=SNAPPY,s_15 FLOAT encoding=PLAIN compression=SNAPPY,s_16 FLOAT encoding=PLAIN compression=SNAPPY,s_17 FLOAT encoding=PLAIN compression=SNAPPY,s_18 FLOAT encoding=PLAIN compression=SNAPPY,s_19 FLOAT encoding=PLAIN compression=SNAPPY,s_25 TEXT encoding=PLAIN compression=SNAPPY,s_26 TEXT encoding=PLAIN compression=SNAPPY,s_27 TEXT encoding=PLAIN compression=SNAPPY,s_28 TEXT encoding=PLAIN compression=SNAPPY,s_29 TEXT encoding=PLAIN compression=SNAPPY)
传感器后直接输入数据类型，可以创建成功（但是有一个告警：15:26:44.864 [main] DEBUG org.apache.iotdb.rpc.AutoResizingBuffer - org.apache.iotdb.rpc.AutoResizingBuffer@1aa7ecca shrink from 2562 to 1442{color:#de350b}如果可以处理的话建议隐藏掉{color}）
!image-2022-01-13-15-30-08-744.png!
相同的template，只是创建时数据类型前多加了 datatype= 就报错了。是否可以考虑加上也不报错呢？
create schema template temp1(s_0 DATATYPE=BOOLEAN encoding=PLAIN compression=SNAPPY,s_1 DATATYPE=BOOLEAN encoding=PLAIN compression=SNAPPY,s_2 DATATYPE=BOOLEAN encoding=PLAIN compression=SNAPPY,s_3 DATATYPE=BOOLEAN encoding=PLAIN compression=SNAPPY,s_4 DATATYPE=BOOLEAN encoding=PLAIN compression=SNAPPY,s_20 DATATYPE=DOUBLE encoding=PLAIN compression=SNAPPY,s_21 DATATYPE=DOUBLE encoding=PLAIN compression=SNAPPY,s_22 DATATYPE=DOUBLE encoding=PLAIN compression=SNAPPY,s_23 DATATYPE=DOUBLE encoding=PLAIN compression=SNAPPY,s_24 DATATYPE=DOUBLE encoding=PLAIN compression=SNAPPY,s_10 DATATYPE=INT64 encoding=PLAIN compression=SNAPPY,s_11 DATATYPE=INT64 encoding=PLAIN compression=SNAPPY,s_12 DATATYPE=INT64 encoding=PLAIN compression=SNAPPY,s_13 DATATYPE=INT64 encoding=PLAIN compression=SNAPPY,s_14 DATATYPE=INT64 encoding=PLAIN compression=SNAPPY,s_5 DATATYPE=INT32 encoding=PLAIN compression=SNAPPY,s_6 DATATYPE=INT32 encoding=PLAIN compression=SNAPPY,s_7 DATATYPE=INT32 encoding=PLAIN compression=SNAPPY,s_8 DATATYPE=INT32 encoding=PLAIN compression=SNAPPY,s_9 DATATYPE=INT32 encoding=PLAIN compression=SNAPPY,s_15 DATATYPE=FLOAT encoding=PLAIN compression=SNAPPY,s_16 DATATYPE=FLOAT encoding=PLAIN compression=SNAPPY,s_17 DATATYPE=FLOAT encoding=PLAIN compression=SNAPPY,s_18 DATATYPE=FLOAT encoding=PLAIN compression=SNAPPY,s_19 DATATYPE=FLOAT encoding=PLAIN compression=SNAPPY,s_25 DATATYPE=TEXT encoding=PLAIN compression=SNAPPY,s_26 DATATYPE=TEXT encoding=PLAIN compression=SNAPPY,s_27 DATATYPE=TEXT encoding=PLAIN compression=SNAPPY,s_28 DATATYPE=TEXT encoding=PLAIN compression=SNAPPY,s_29 DATATYPE=TEXT encoding=PLAIN compression=SNAPPY)
!image-2022-01-13-15-34-40-768.png!
--
This message was sent by Atlassian Jira
(v8.20.1#820001)