[jira] [Commented] (IOTDB-2380) Upgrade SQL of schema template

["FengQingxin (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IOTDB-2380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17475995#comment-17475995 ] 

FengQingxin commented on IOTDB-2380:
------------------------------------

h1. [需求]

创建全部是对齐时间序列的模板

1.create template temp1 (aligned (latitude FLOAT , longitude FLOAT))

2.create aligned template temp1 (latitude FLOAT , longitude FLOAT)

如果是多层级的是否可以：创建包含对齐时间序列的模板

1.create template temp1（aligned( GPS(latitude FLOAT , longitude FLOAT ),status TEXT), speed DOUBLE）

> Upgrade SQL of schema template
> ------------------------------
>
>                 Key: IOTDB-2380
>                 URL: https://issues.apache.org/jira/browse/IOTDB-2380
>             Project: Apache IoTDB
>          Issue Type: New Feature
>          Components: Client/CLI
>    Affects Versions: 0.13.0-SNAPSHOT
>            Reporter: FengQingxin
>            Assignee: Minghui Liu
>            Priority: Major
>
> After IOTDB-1883 & IOTDB-1931, the feature of the schema template has changed. So, we should refactor SQL of schema templates to adapt it.
> h2. [需求]
> 目前看创建和挂载卸载能力已经具备。但是处于系统操作全面考虑有如下建议：
> 添加查看和删除SQL语句
> 这样对于Template的管理就更全面了：
> 创建：create schema template temp1();
> 查看：（所有）show schema template；（某一个或多个）show schema template temp1,temp2；
> 挂载：set schema template temp1 to root.ln.wf01
> 查看：show schema template root.ln.beijing; （待定，优先级最低）查看路径上挂载的信息
> 卸载：unset schema template temp1 from root.beijing
> 删除：drop schema template temp1；



--
This message was sent by Atlassian Jira
(v8.20.1#820001)