| (window.webpackJsonp=window.webpackJsonp||[]).push([[513],{907:function(s,a,t){"use strict";t.r(a);var e=t(29),r=Object(e.a)({},(function(){var s=this,a=s._self._c;return a("ContentSlotsDistributor",{attrs:{"slot-key":s.$parent.slotKey}},[a("h1",{attrs:{id:"元数据模板"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#元数据模板"}},[s._v("#")]),s._v(" 元数据模板")]),s._v(" "),a("p",[s._v("IoTDB 支持元数据模板功能，实现同类型不同实体的物理量元数据共享，减少元数据内存占用，同时简化同类型实体的管理。")]),s._v(" "),a("p",[s._v("注：以下语句中的 "),a("code",[s._v("schema")]),s._v(" 关键字可以省略。")]),s._v(" "),a("h2",{attrs:{id:"创建元数据模板"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#创建元数据模板"}},[s._v("#")]),s._v(" 创建元数据模板")]),s._v(" "),a("p",[s._v("创建元数据模板的 SQL 语法如下：")]),s._v(" "),a("div",{staticClass:"language-sql line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-sql"}},[a("code",[a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("CREATE")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("SCHEMA")]),s._v("? TEMPLATE "),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("<")]),s._v("templateName"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" ALIGNED? "),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'('")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("<")]),s._v("measurementId"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("<")]),s._v("attributeClauses"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("[")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("','")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("<")]),s._v("measurementId"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("<")]),s._v("attributeClauses"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("]")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("+")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("')'")]),s._v("\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[a("strong",[s._v("示例1：")]),s._v(" 创建包含两个非对齐序列的元数据模板")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("IoTDB"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" create schema template t1 "),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("temperature FLOAT "),a("span",{pre:!0,attrs:{class:"token assign-left variable"}},[s._v("encoding")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),s._v("RLE, status BOOLEAN "),a("span",{pre:!0,attrs:{class:"token assign-left variable"}},[s._v("encoding")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),s._v("PLAIN "),a("span",{pre:!0,attrs:{class:"token assign-left variable"}},[s._v("compression")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),s._v("SNAPPY"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v("\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[a("strong",[s._v("示例2：")]),s._v(" 创建包含一组对齐序列的元数据模板")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("IoTDB"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" create schema template t2 aligned "),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("lat FLOAT "),a("span",{pre:!0,attrs:{class:"token assign-left variable"}},[s._v("encoding")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),s._v("Gorilla, lon FLOAT "),a("span",{pre:!0,attrs:{class:"token assign-left variable"}},[s._v("encoding")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),s._v("Gorilla"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v("\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[s._v("其中，物理量 "),a("code",[s._v("lat")]),s._v(" 和 "),a("code",[s._v("lon")]),s._v(" 是对齐的。")]),s._v(" "),a("h2",{attrs:{id:"挂载元数据模板"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#挂载元数据模板"}},[s._v("#")]),s._v(" 挂载元数据模板")]),s._v(" "),a("p",[a("strong",[s._v("为了更好地适配未来版本的更新及各模块的协作，我们强烈建议您将模板设置在存储组及存储组下层的节点中。")])]),s._v(" "),a("p",[s._v("挂载元数据模板的 SQL 语句如下所示：")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("IoTDB"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token builtin class-name"}},[s._v("set")]),s._v(" schema template t1 to root.sg1.d1\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[s._v("挂载好元数据模板后，即可进行数据的写入。例如存储组为 root.sg1，模板 t1 被挂载到了节点 root.sg1.d1，那么可直接向时间序列（如 root.sg1.d1.temperature 和 root.sg1.d1.status）写入时间序列数据，该时间序列已可被当作正常创建的序列使用。")]),s._v(" "),a("p",[a("strong",[s._v("注意")]),s._v("：在插入数据之前，模板定义的时间序列不会被创建。可以使用如下SQL语句在插入数据前创建时间序列：")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("IoTDB"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" create timeseries of schema template on root.sg1.d1\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[a("strong",[s._v("示例：")]),s._v(" 执行以下语句")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[a("span",{pre:!0,attrs:{class:"token builtin class-name"}},[s._v("set")]),s._v(" schema template t1 to root.sg1.d1\n"),a("span",{pre:!0,attrs:{class:"token builtin class-name"}},[s._v("set")]),s._v(" schema template t2 to root.sg1.d2\ncreate timeseries of schema template on root.sg1.d1\ncreate timeseries of schema template on root.sg1.d2\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br"),a("span",{staticClass:"line-number"},[s._v("2")]),a("br"),a("span",{staticClass:"line-number"},[s._v("3")]),a("br"),a("span",{staticClass:"line-number"},[s._v("4")]),a("br")])]),a("p",[s._v("查看此时的时间序列：")]),s._v(" "),a("div",{staticClass:"language-sql line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-sql"}},[a("code",[a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("show")]),s._v(" timeseries root"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("*")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("*")]),s._v("\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("+-----------------------+-----+-------------+--------+--------+-----------+----+----------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" timeseries"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),a("span",{pre:!0,attrs:{class:"token builtin class-name"}},[s._v("alias")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("storage group"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("dataType"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("encoding"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("compression"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("tags"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("attributes"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+-----------------------+-----+-------------+--------+--------+-----------+----+----------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("root.sg1.d1.temperature"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" root.sg1"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" FLOAT"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" RLE"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" SNAPPY"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" root.sg1.d1.status"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" root.sg1"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" BOOLEAN"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" PLAIN"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" SNAPPY"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" root.sg1.d2.lon"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" root.sg1"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" FLOAT"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" GORILLA"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" SNAPPY"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" root.sg1.d2.lat"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" root.sg1"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" FLOAT"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" GORILLA"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" SNAPPY"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" null"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+-----------------------+-----+-------------+--------+--------+-----------+----+----------+\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br"),a("span",{staticClass:"line-number"},[s._v("2")]),a("br"),a("span",{staticClass:"line-number"},[s._v("3")]),a("br"),a("span",{staticClass:"line-number"},[s._v("4")]),a("br"),a("span",{staticClass:"line-number"},[s._v("5")]),a("br"),a("span",{staticClass:"line-number"},[s._v("6")]),a("br"),a("span",{staticClass:"line-number"},[s._v("7")]),a("br"),a("span",{staticClass:"line-number"},[s._v("8")]),a("br")])]),a("p",[s._v("查看此时的设备：")]),s._v(" "),a("div",{staticClass:"language-sql line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-sql"}},[a("code",[a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("show")]),s._v(" devices root"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("*")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("*")]),s._v("\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("+---------------+---------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" devices"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("isAligned"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+---------------+---------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" root.sg1.d1"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token boolean"}},[s._v("false")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" root.sg1.d2"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token boolean"}},[s._v("true")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+---------------+---------+\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br"),a("span",{staticClass:"line-number"},[s._v("2")]),a("br"),a("span",{staticClass:"line-number"},[s._v("3")]),a("br"),a("span",{staticClass:"line-number"},[s._v("4")]),a("br"),a("span",{staticClass:"line-number"},[s._v("5")]),a("br"),a("span",{staticClass:"line-number"},[s._v("6")]),a("br")])]),a("h2",{attrs:{id:"查看元数据模板"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#查看元数据模板"}},[s._v("#")]),s._v(" 查看元数据模板")]),s._v(" "),a("ul",[a("li",[s._v("查看所有元数据模板")])]),s._v(" "),a("p",[s._v("SQL 语句如下所示：")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("IoTDB"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" show schema templates\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[s._v("执行结果如下：")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("+-------------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("template name"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+-------------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" t2"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" t1"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+-------------+\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br"),a("span",{staticClass:"line-number"},[s._v("2")]),a("br"),a("span",{staticClass:"line-number"},[s._v("3")]),a("br"),a("span",{staticClass:"line-number"},[s._v("4")]),a("br"),a("span",{staticClass:"line-number"},[s._v("5")]),a("br"),a("span",{staticClass:"line-number"},[s._v("6")]),a("br")])]),a("ul",[a("li",[s._v("查看某个元数据模板下的物理量")])]),s._v(" "),a("p",[s._v("SQL 语句如下所示：")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("IoTDB"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" show nodes "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("in")]),s._v(" schema template t1\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[s._v("执行结果如下：")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("+-----------+--------+--------+-----------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("child nodes"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("dataType"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("encoding"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("compression"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+-----------+--------+--------+-----------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("temperature"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" FLOAT"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" RLE"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" SNAPPY"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" status"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" BOOLEAN"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" PLAIN"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v(" SNAPPY"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+-----------+--------+--------+-----------+\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br"),a("span",{staticClass:"line-number"},[s._v("2")]),a("br"),a("span",{staticClass:"line-number"},[s._v("3")]),a("br"),a("span",{staticClass:"line-number"},[s._v("4")]),a("br"),a("span",{staticClass:"line-number"},[s._v("5")]),a("br"),a("span",{staticClass:"line-number"},[s._v("6")]),a("br")])]),a("ul",[a("li",[s._v("查看挂载了某个元数据模板的路径前缀")])]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("IoTDB"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" show paths "),a("span",{pre:!0,attrs:{class:"token builtin class-name"}},[s._v("set")]),s._v(" schema template t1\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[s._v("执行结果如下：")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("+-----------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("child paths"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+-----------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("root.sg1.d1"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+-----------+\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br"),a("span",{staticClass:"line-number"},[s._v("2")]),a("br"),a("span",{staticClass:"line-number"},[s._v("3")]),a("br"),a("span",{staticClass:"line-number"},[s._v("4")]),a("br"),a("span",{staticClass:"line-number"},[s._v("5")]),a("br")])]),a("ul",[a("li",[s._v("查看使用了某个元数据模板（即序列已创建）的路径前缀")])]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("IoTDB"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" show paths using schema template t1\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[s._v("执行结果如下：")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("+-----------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("child paths"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+-----------+\n"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("root.sg1.d1"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("|")]),s._v("\n+-----------+\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br"),a("span",{staticClass:"line-number"},[s._v("2")]),a("br"),a("span",{staticClass:"line-number"},[s._v("3")]),a("br"),a("span",{staticClass:"line-number"},[s._v("4")]),a("br"),a("span",{staticClass:"line-number"},[s._v("5")]),a("br")])]),a("h2",{attrs:{id:"卸载元数据模板"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#卸载元数据模板"}},[s._v("#")]),s._v(" 卸载元数据模板")]),s._v(" "),a("p",[s._v("卸载元数据模板的 SQL 语句如下所示：")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("IoTDB"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token builtin class-name"}},[s._v("unset")]),s._v(" schema template t1 from root.sg1.d1\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[a("strong",[s._v("注意")]),s._v("：目前不支持从曾经使用模板插入数据后（即使数据已被删除）的实体中卸载模板。")]),s._v(" "),a("h2",{attrs:{id:"删除元数据模板"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#删除元数据模板"}},[s._v("#")]),s._v(" 删除元数据模板")]),s._v(" "),a("p",[s._v("删除元数据模板的 SQL 语句如下所示：")]),s._v(" "),a("div",{staticClass:"language-shell line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-shell"}},[a("code",[s._v("IoTDB"),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v(">")]),s._v(" drop schema template t1\n")])]),s._v(" "),a("div",{staticClass:"line-numbers-wrapper"},[a("span",{staticClass:"line-number"},[s._v("1")]),a("br")])]),a("p",[a("strong",[s._v("注意")]),s._v("：不支持删除已经挂载的模板。")])])}),[],!1,null,null,null);a.default=r.exports}}]); |