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