[IOTDB-2382] [Template] can't use datatype in SQL

• Type: Wish
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 0.13.0-SNAPSHOT
• Component/s: Client/CLI
• Labels: 0.13.0
• Assignee: Minghui Liu
• Reporter: FengQingxin
• Created: 13/Jan/22 07:28
• Updated: 19/Jan/22 08:32
• Resolved: 14/Jan/22 06:51

Description

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如果可以处理的话建议隐藏掉）

相同的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)

 

 

Issue Links

• is a clone of: IOTDB-2298 Refactor SQL of schema template
• is cloned by: IOTDB-2383 Make simplified SQL of creating timeseries and schema template more flexible
• is fixed by: IOTDB-2383 Make simplified SQL of creating timeseries and schema template more flexible