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:43:00 UTC
[jira] [Commented] (IOTDB-2382) [Template] can't use datatype in SQL
[ https://issues.apache.org/jira/browse/IOTDB-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17475158#comment-17475158 ]
FengQingxin commented on IOTDB-2382:
------------------------------------
我也创建了 IOTDB-2383
创建时间序列的简化版可不可以输入了datatype也能支持创建？
如果他们解决了，那么create template也就解决了。
> [Template] can't use datatype in SQL
> -------------------------------------
>
> Key: IOTDB-2382
> URL: https://issues.apache.org/jira/browse/IOTDB-2382
> Project: Apache IoTDB
> Issue Type: Wish
> Components: Client/CLI
> Affects Versions: 0.13.0-SNAPSHOT
> Reporter: FengQingxin
> Assignee: Minghui Liu
> Priority: Minor
> Labels: 0.13.0
> Attachments: image-2022-01-13-15-30-08-744.png, image-2022-01-13-15-34-40-768.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)