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)

Reply via email to