| (window.webpackJsonp=window.webpackJsonp||[]).push([[754],{1152:function(s,e,t){"use strict";t.r(e);var a=t(29),r=Object(a.a)({},(function(){var s=this,e=s._self._c;return e("ContentSlotsDistributor",{attrs:{"slot-key":s.$parent.slotKey}},[e("h1",{attrs:{id:"存储组管理"}},[e("a",{staticClass:"header-anchor",attrs:{href:"#存储组管理"}},[s._v("#")]),s._v(" 存储组管理")]),s._v(" "),e("h2",{attrs:{id:"创建存储组"}},[e("a",{staticClass:"header-anchor",attrs:{href:"#创建存储组"}},[s._v("#")]),s._v(" 创建存储组")]),s._v(" "),e("p",[s._v("我们可以根据存储模型建立相应的存储组。创建存储组支持两种 SQL 语句，如下所示：")]),s._v(" "),e("div",{staticClass:"language- line-numbers-mode"},[e("pre",{pre:!0,attrs:{class:"language-text"}},[e("code",[s._v("IoTDB > set storage group to root.ln\nIoTDB > create storage group root.sgcc\n")])]),s._v(" "),e("div",{staticClass:"line-numbers-wrapper"},[e("span",{staticClass:"line-number"},[s._v("1")]),e("br"),e("span",{staticClass:"line-number"},[s._v("2")]),e("br")])]),e("p",[s._v("根据以上两条 SQL 语句，我们可以创建出两个存储组。")]),s._v(" "),e("p",[s._v("需要注意的是，存储组的父子节点都不能再设置存储组。例如在已经有"),e("code",[s._v("root.ln")]),s._v("和"),e("code",[s._v("root.sgcc")]),s._v("这两个存储组的情况下，创建"),e("code",[s._v("root.ln.wf01")]),s._v("存储组是不可行的。系统将给出相应的错误提示，如下所示：")]),s._v(" "),e("div",{staticClass:"language- line-numbers-mode"},[e("pre",{pre:!0,attrs:{class:"language-text"}},[e("code",[s._v("IoTDB> set storage group to root.ln.wf01\nMsg: 300: root.ln has already been set to storage group.\nIoTDB> create storage group root.ln.wf01\nMsg: 300: root.ln has already been set to storage group.\n")])]),s._v(" "),e("div",{staticClass:"line-numbers-wrapper"},[e("span",{staticClass:"line-number"},[s._v("1")]),e("br"),e("span",{staticClass:"line-number"},[s._v("2")]),e("br"),e("span",{staticClass:"line-number"},[s._v("3")]),e("br"),e("span",{staticClass:"line-number"},[s._v("4")]),e("br")])]),e("p",[s._v("存储组节点名只支持中英文字符、数字、下划线和中划线的组合。")]),s._v(" "),e("p",[s._v("还需注意，如果在 Windows 系统上部署，存储组名是大小写不敏感的。例如同时创建"),e("code",[s._v("root.ln")]),s._v(" 和 "),e("code",[s._v("root.LN")]),s._v(" 是不被允许的。")]),s._v(" "),e("h2",{attrs:{id:"查看存储组"}},[e("a",{staticClass:"header-anchor",attrs:{href:"#查看存储组"}},[s._v("#")]),s._v(" 查看存储组")]),s._v(" "),e("p",[s._v("在存储组创建后，我们可以使用 "),e("RouterLink",{attrs:{to:"/zh/UserGuide/V0.13.x/Reference/SQL-Reference.html"}},[s._v("SHOW STORAGE GROUP")]),s._v(" 语句和 "),e("RouterLink",{attrs:{to:"/zh/UserGuide/V0.13.x/Reference/SQL-Reference.html"}},[s._v("SHOW STORAGE GROUP <PathPattern>")]),s._v(" 来查看存储组，SQL 语句如下所示：")],1),s._v(" "),e("div",{staticClass:"language- line-numbers-mode"},[e("pre",{pre:!0,attrs:{class:"language-text"}},[e("code",[s._v("IoTDB> show storage group\nIoTDB> show storage group root.*\nIoTDB> show storage group root.**\n")])]),s._v(" "),e("div",{staticClass:"line-numbers-wrapper"},[e("span",{staticClass:"line-number"},[s._v("1")]),e("br"),e("span",{staticClass:"line-number"},[s._v("2")]),e("br"),e("span",{staticClass:"line-number"},[s._v("3")]),e("br")])]),e("p",[s._v("执行结果为：")]),s._v(" "),e("div",{staticClass:"language- line-numbers-mode"},[e("pre",{pre:!0,attrs:{class:"language-text"}},[e("code",[s._v("+-------------+\n|storage group|\n+-------------+\n| root.sgcc|\n| root.ln|\n+-------------+\nTotal line number = 2\nIt costs 0.060s\n")])]),s._v(" "),e("div",{staticClass:"line-numbers-wrapper"},[e("span",{staticClass:"line-number"},[s._v("1")]),e("br"),e("span",{staticClass:"line-number"},[s._v("2")]),e("br"),e("span",{staticClass:"line-number"},[s._v("3")]),e("br"),e("span",{staticClass:"line-number"},[s._v("4")]),e("br"),e("span",{staticClass:"line-number"},[s._v("5")]),e("br"),e("span",{staticClass:"line-number"},[s._v("6")]),e("br"),e("span",{staticClass:"line-number"},[s._v("7")]),e("br"),e("span",{staticClass:"line-number"},[s._v("8")]),e("br")])]),e("h2",{attrs:{id:"删除存储组"}},[e("a",{staticClass:"header-anchor",attrs:{href:"#删除存储组"}},[s._v("#")]),s._v(" 删除存储组")]),s._v(" "),e("p",[s._v("用户可以使用"),e("code",[s._v("DELETE STORAGE GROUP <PathPattern>")]),s._v("语句删除该路径模式匹配的所有的存储组。在删除的过程中，需要注意的是存储组的数据也会被删除。")]),s._v(" "),e("div",{staticClass:"language- line-numbers-mode"},[e("pre",{pre:!0,attrs:{class:"language-text"}},[e("code",[s._v("IoTDB > DELETE STORAGE GROUP root.ln\nIoTDB > DELETE STORAGE GROUP root.sgcc\n// 删除所有数据，时间序列以及存储组\nIoTDB > DELETE STORAGE GROUP root.**\n")])]),s._v(" "),e("div",{staticClass:"line-numbers-wrapper"},[e("span",{staticClass:"line-number"},[s._v("1")]),e("br"),e("span",{staticClass:"line-number"},[s._v("2")]),e("br"),e("span",{staticClass:"line-number"},[s._v("3")]),e("br"),e("span",{staticClass:"line-number"},[s._v("4")]),e("br")])])])}),[],!1,null,null,null);e.default=r.exports}}]); |