| (window.webpackJsonp=window.webpackJsonp||[]).push([[552],{949:function(s,t,a){"use strict";a.r(t);var n=a(29),e=Object(n.a)({},(function(){var s=this,t=s._self._c;return t("ContentSlotsDistributor",{attrs:{"slot-key":s.$parent.slotKey}},[t("h1",{attrs:{id:"字符串处理"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#字符串处理"}},[s._v("#")]),s._v(" 字符串处理")]),s._v(" "),t("h2",{attrs:{id:"length"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#length"}},[s._v("#")]),s._v(" Length")]),s._v(" "),t("h3",{attrs:{id:"函数简介"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于获取输入序列的长度。")]),s._v(" "),t("p",[t("strong",[s._v("函数名:")]),s._v(" LENGTH")]),s._v(" "),t("p",[t("strong",[s._v("输入序列:")]),s._v(" 仅支持单个输入序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("输出序列:")]),s._v(" 输出单个序列，类型为 INT32。")]),s._v(" "),t("p",[t("strong",[s._v("提示:")]),s._v(" 如果输入是NULL，返回NULL。")]),s._v(" "),t("h3",{attrs:{id:"使用示例"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+\n| Time|root.sg1.d1.s1|\n+-----------------------------+--------------+\n|1970-01-01T08:00:00.001+08:00| 1test1|\n|1970-01-01T08:00:00.002+08:00| 22test22|\n+-----------------------------+--------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" length"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+----------------------+\n| Time|root.sg1.d1.s1|length(root.sg1.d1.s1)|\n+-----------------------------+--------------+----------------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| 6|\n|1970-01-01T08:00:00.002+08:00| 22test22| 8|\n+-----------------------------+--------------+----------------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("h2",{attrs:{id:"strlocate"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#strlocate"}},[s._v("#")]),s._v(" StrLocate")]),s._v(" "),t("h3",{attrs:{id:"函数简介-2"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-2"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于获取"),t("code",[s._v("target")]),s._v("子串第一次出现在输入序列的位置，如果输入序列中不包含"),t("code",[s._v("target")]),s._v("则返回 -1 。")]),s._v(" "),t("p",[t("strong",[s._v("函数名:")]),s._v(" LENGTH")]),s._v(" "),t("p",[t("strong",[s._v("输入序列:")]),s._v(" 仅支持单个输入序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("参数:")])]),s._v(" "),t("ul",[t("li",[t("code",[s._v("target")]),s._v(": 需要被定位的子串。")]),s._v(" "),t("li",[t("code",[s._v("reverse")]),s._v(": 指定是否需要倒序定位，默认值为"),t("code",[s._v("false")]),s._v(", 即从左至右定位。")])]),s._v(" "),t("p",[t("strong",[s._v("输出序列:")]),s._v(" 输出单个序列，类型为INT32。")]),s._v(" "),t("p",[t("strong",[s._v("提示:")]),s._v(" 下标从 0 开始。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-2"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-2"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+\n| Time|root.sg1.d1.s1|\n+-----------------------------+--------------+\n|1970-01-01T08:00:00.001+08:00| 1test1|\n|1970-01-01T08:00:00.002+08:00| 22test22|\n+-----------------------------+--------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" locate"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"target"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"1"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+--------------+------------------------------------+\n| Time|root.sg1.d1.s1|locate(root.sg1.d1.s1, "target"="1")|\n+-----------------------------+--------------+------------------------------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| 0|\n|1970-01-01T08:00:00.002+08:00| 22test22| -1|\n+-----------------------------+--------------+------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("另一个用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" locate"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"target"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"1"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"reverse"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"true"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+--------------+------------------------------------------------------+\n| Time|root.sg1.d1.s1|locate(root.sg1.d1.s1, "target"="1", "reverse"="true")|\n+-----------------------------+--------------+------------------------------------------------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| 5|\n|1970-01-01T08:00:00.002+08:00| 22test22| -1|\n+-----------------------------+--------------+------------------------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("h2",{attrs:{id:"startswith"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#startswith"}},[s._v("#")]),s._v(" StartsWith")]),s._v(" "),t("h3",{attrs:{id:"函数简介-3"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-3"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于判断输入序列是否有指定前缀。")]),s._v(" "),t("p",[t("strong",[s._v("函数名:")]),s._v(" STARTSWITH")]),s._v(" "),t("p",[t("strong",[s._v("输入序列:")]),s._v(" 仅支持单个输入序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("参数:")])]),s._v(" "),t("ul",[t("li",[t("code",[s._v("target")]),s._v(": 需要匹配的前缀。")])]),s._v(" "),t("p",[t("strong",[s._v("输出序列:")]),s._v(" 输出单个序列，类型为 BOOLEAN。")]),s._v(" "),t("p",[t("strong",[s._v("提示:")]),s._v(" 如果输入是NULL，返回NULL。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-3"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-3"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+\n| Time|root.sg1.d1.s1|\n+-----------------------------+--------------+\n|1970-01-01T08:00:00.001+08:00| 1test1|\n|1970-01-01T08:00:00.002+08:00| 22test22|\n+-----------------------------+--------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" startswith"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"target"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"1"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+--------------+----------------------------------------+\n| Time|root.sg1.d1.s1|startswith(root.sg1.d1.s1, "target"="1")|\n+-----------------------------+--------------+----------------------------------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| true|\n|1970-01-01T08:00:00.002+08:00| 22test22| false|\n+-----------------------------+--------------+----------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("h2",{attrs:{id:"endswith"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#endswith"}},[s._v("#")]),s._v(" EndsWith")]),s._v(" "),t("h3",{attrs:{id:"函数简介-4"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-4"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于判断输入序列是否有指定后缀。")]),s._v(" "),t("p",[t("strong",[s._v("函数名:")]),s._v(" ENDSWITH")]),s._v(" "),t("p",[t("strong",[s._v("输入序列:")]),s._v(" 仅支持单个输入序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("参数:")])]),s._v(" "),t("ul",[t("li",[t("code",[s._v("target")]),s._v(": 需要匹配的后缀。")])]),s._v(" "),t("p",[t("strong",[s._v("输出序列:")]),s._v(" 输出单个序列，类型为 BOOLEAN。")]),s._v(" "),t("p",[t("strong",[s._v("提示:")]),s._v(" 如果输入是NULL，返回NULL。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-4"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-4"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+\n| Time|root.sg1.d1.s1|\n+-----------------------------+--------------+\n|1970-01-01T08:00:00.001+08:00| 1test1|\n|1970-01-01T08:00:00.002+08:00| 22test22|\n+-----------------------------+--------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" endswith"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"target"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"1"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+--------------+--------------------------------------+\n| Time|root.sg1.d1.s1|endswith(root.sg1.d1.s1, "target"="1")|\n+-----------------------------+--------------+--------------------------------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| true|\n|1970-01-01T08:00:00.002+08:00| 22test22| false|\n+-----------------------------+--------------+--------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("h2",{attrs:{id:"concat"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#concat"}},[s._v("#")]),s._v(" Concat")]),s._v(" "),t("h3",{attrs:{id:"函数简介-5"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-5"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于拼接输入序列和"),t("code",[s._v("target")]),s._v("字串。")]),s._v(" "),t("p",[t("strong",[s._v("函数名:")]),s._v(" CONCAT")]),s._v(" "),t("p",[t("strong",[s._v("输入序列:")]),s._v(" 至少一个输入序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("参数:")])]),s._v(" "),t("ul",[t("li",[t("code",[s._v("targets")]),s._v(": 一系列 K-V, key需要以"),t("code",[s._v("target")]),s._v("为前缀且不重复, value是待拼接的字符串。")]),s._v(" "),t("li",[t("code",[s._v("series_behind")]),s._v(": 指定拼接时时间序列是否在后面，默认为"),t("code",[s._v("false")]),s._v("。")])]),s._v(" "),t("p",[t("strong",[s._v("输出序列:")]),s._v(" 输出单个序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("提示:")])]),s._v(" "),t("ul",[t("li",[s._v("如果输入序列是NULL, 跳过该序列的拼接。")]),s._v(" "),t("li",[s._v("函数只能将输入序列和"),t("code",[s._v("targets")]),s._v("区分开各自拼接。"),t("code",[s._v('concat(s1, "target1"="IoT", s2, "target2"="DB")')]),s._v("和\n"),t("code",[s._v('concat(s1, s2, "target1"="IoT", "target2"="DB")')]),s._v("得到的结果是一样的。")])]),s._v(" "),t("h3",{attrs:{id:"使用示例-5"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-5"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+--------------+\n| Time|root.sg1.d1.s1|root.sg1.d1.s2|\n+-----------------------------+--------------+--------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| null|\n|1970-01-01T08:00:00.002+08:00| 22test22| 2222test|\n+-----------------------------+--------------+--------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" s2"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" concat"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" s2"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"target1"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"IoT"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"target2"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"DB"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+--------------+--------------+-----------------------------------------------------------------------+\n| Time|root.sg1.d1.s1|root.sg1.d1.s2|concat(root.sg1.d1.s1, root.sg1.d1.s2, "target1"="IoT", "target2"="DB")|\n+-----------------------------+--------------+--------------+-----------------------------------------------------------------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| null| 1test1IoTDB|\n|1970-01-01T08:00:00.002+08:00| 22test22| 2222test| 22test222222testIoTDB|\n+-----------------------------+--------------+--------------+-----------------------------------------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("另一个用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" s2"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" concat"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" s2"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"target1"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"IoT"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"target2"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"DB"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"series_behind"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"true"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+--------------+--------------+-----------------------------------------------------------------------------------------------+\n| Time|root.sg1.d1.s1|root.sg1.d1.s2|concat(root.sg1.d1.s1, root.sg1.d1.s2, "target1"="IoT", "target2"="DB", "series_behind"="true")|\n+-----------------------------+--------------+--------------+-----------------------------------------------------------------------------------------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| null| IoTDB1test1|\n|1970-01-01T08:00:00.002+08:00| 22test22| 2222test| IoTDB22test222222test|\n+-----------------------------+--------------+--------------+-----------------------------------------------------------------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("h2",{attrs:{id:"substr"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#substr"}},[s._v("#")]),s._v(" Substr")]),s._v(" "),t("h3",{attrs:{id:"函数简介-6"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-6"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于获取下标从"),t("code",[s._v("start")]),s._v("到"),t("code",[s._v("end - 1")]),s._v("的子串")]),s._v(" "),t("p",[t("strong",[s._v("函数名:")]),s._v(" SUBSTR")]),s._v(" "),t("p",[t("strong",[s._v("输入序列:")]),s._v(" 仅支持单个输入序列，类型为TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("参数:")])]),s._v(" "),t("ul",[t("li",[t("code",[s._v("start")]),s._v(": 指定子串开始下标。")]),s._v(" "),t("li",[t("code",[s._v("end")]),s._v(": 指定子串结束下标。")])]),s._v(" "),t("p",[t("strong",[s._v("输出序列:")]),s._v(" 输出单个序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("提示:")]),s._v(" 如果输入是NULL，返回NULL。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-6"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-6"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+\n| Time|root.sg1.d1.s1|\n+-----------------------------+--------------+\n|1970-01-01T08:00:00.001+08:00| 1test1|\n|1970-01-01T08:00:00.002+08:00| 22test22|\n+-----------------------------+--------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" substr"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"start"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"0"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"end"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"2"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+--------------+----------------------------------------------+\n| Time|root.sg1.d1.s1|substr(root.sg1.d1.s1, "start"="0", "end"="2")|\n+-----------------------------+--------------+----------------------------------------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| 1t|\n|1970-01-01T08:00:00.002+08:00| 22test22| 22|\n+-----------------------------+--------------+----------------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("h2",{attrs:{id:"upper"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#upper"}},[s._v("#")]),s._v(" Upper")]),s._v(" "),t("h3",{attrs:{id:"函数简介-7"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-7"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于将输入序列转化为大写。")]),s._v(" "),t("p",[t("strong",[s._v("函数名:")]),s._v(" UPPER")]),s._v(" "),t("p",[t("strong",[s._v("输入序列:")]),s._v(" 仅支持单个输入序列，类型为TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("输出序列:")]),s._v(" 输出单个序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("提示:")]),s._v(" 如果输入是NULL，返回NULL。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-7"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-7"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+\n| Time|root.sg1.d1.s1|\n+-----------------------------+--------------+\n|1970-01-01T08:00:00.001+08:00| 1test1|\n|1970-01-01T08:00:00.002+08:00| 22test22|\n+-----------------------------+--------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" upper"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+---------------------+\n| Time|root.sg1.d1.s1|upper(root.sg1.d1.s1)|\n+-----------------------------+--------------+---------------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| 1TEST1|\n|1970-01-01T08:00:00.002+08:00| 22test22| 22TEST22|\n+-----------------------------+--------------+---------------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("h2",{attrs:{id:"lower"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#lower"}},[s._v("#")]),s._v(" Lower")]),s._v(" "),t("h3",{attrs:{id:"函数简介-8"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-8"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于将输入序列转换为小写。")]),s._v(" "),t("p",[t("strong",[s._v("函数名:")]),s._v(" LOWER")]),s._v(" "),t("p",[t("strong",[s._v("输入序列:")]),s._v(" 仅支持单个输入序列，类型为TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("输出序列:")]),s._v(" 输出单个序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("提示:")]),s._v(" 如果输入是NULL，返回NULL。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-8"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-8"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+\n| Time|root.sg1.d1.s1|\n+-----------------------------+--------------+\n|1970-01-01T08:00:00.001+08:00| 1TEST1|\n|1970-01-01T08:00:00.002+08:00| 22TEST22|\n+-----------------------------+--------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" lower"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+---------------------+\n| Time|root.sg1.d1.s1|lower(root.sg1.d1.s1)|\n+-----------------------------+--------------+---------------------+\n|1970-01-01T08:00:00.001+08:00| 1TEST1| 1test1|\n|1970-01-01T08:00:00.002+08:00| 22TEST22| 22test22|\n+-----------------------------+--------------+---------------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("h2",{attrs:{id:"trim"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#trim"}},[s._v("#")]),s._v(" Trim")]),s._v(" "),t("h3",{attrs:{id:"函数简介-9"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-9"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于移除输入序列前后的空格。")]),s._v(" "),t("p",[t("strong",[s._v("函数名:")]),s._v(" TRIM")]),s._v(" "),t("p",[t("strong",[s._v("输入序列:")]),s._v(" 仅支持单个输入序列，类型为TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("输出序列:")]),s._v(" 输出单个序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("提示:")]),s._v(" 如果输入是NULL，返回NULL。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-9"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-9"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+\n| Time|root.sg1.d1.s3|\n+-----------------------------+--------------+\n|1970-01-01T08:00:00.002+08:00| 3querytest3|\n|1970-01-01T08:00:00.003+08:00| 3querytest3 |\n+-----------------------------+--------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s3"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" trim"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s3"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+--------------------+\n| Time|root.sg1.d1.s3|trim(root.sg1.d1.s3)|\n+-----------------------------+--------------+--------------------+\n|1970-01-01T08:00:00.002+08:00| 3querytest3| 3querytest3|\n|1970-01-01T08:00:00.003+08:00| 3querytest3 | 3querytest3|\n+-----------------------------+--------------+--------------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("h2",{attrs:{id:"strcmp"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#strcmp"}},[s._v("#")]),s._v(" StrCmp")]),s._v(" "),t("h3",{attrs:{id:"函数简介-10"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-10"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于比较两个输入序列。 如果值相同返回 "),t("code",[s._v("0")]),s._v(" , 序列1的值小于序列2的值返回一个"),t("code",[s._v("负数")]),s._v("，序列1的值大于序列2的值返回一个"),t("code",[s._v("正数")]),s._v("。")]),s._v(" "),t("p",[t("strong",[s._v("函数名:")]),s._v(" StrCmp")]),s._v(" "),t("p",[t("strong",[s._v("输入序列:")]),s._v(" 输入两个序列，类型均为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("输出序列:")]),s._v(" 输出单个序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("提示:")]),s._v(" 如果任何一个输入是NULL，返回NULL。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-10"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-10"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+--------------+\n| Time|root.sg1.d1.s1|root.sg1.d1.s2|\n+-----------------------------+--------------+--------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| null|\n|1970-01-01T08:00:00.002+08:00| 22test22| 2222test|\n+-----------------------------+--------------+--------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句:")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" s2"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" strcmp"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" s2"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("sg1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列:")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------+--------------+--------------------------------------+\n| Time|root.sg1.d1.s1|root.sg1.d1.s2|strcmp(root.sg1.d1.s1, root.sg1.d1.s2)|\n+-----------------------------+--------------+--------------+--------------------------------------+\n|1970-01-01T08:00:00.001+08:00| 1test1| null| null|\n|1970-01-01T08:00:00.002+08:00| 22test22| 2222test| 66|\n+-----------------------------+--------------+--------------+--------------------------------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br")])]),t("h2",{attrs:{id:"strreplace"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#strreplace"}},[s._v("#")]),s._v(" StrReplace")]),s._v(" "),t("h3",{attrs:{id:"函数简介-11"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-11"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于将文本中的子串替换为指定的字符串。")]),s._v(" "),t("p",[t("strong",[s._v("函数名：")]),s._v(" STRREPLACE")]),s._v(" "),t("p",[t("strong",[s._v("输入序列：")]),s._v(" 仅支持单个输入序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("参数：")])]),s._v(" "),t("ul",[t("li",[t("code",[s._v("target")]),s._v(": 需要替换的字符子串")]),s._v(" "),t("li",[t("code",[s._v("replace")]),s._v(": 替换后的字符串。")]),s._v(" "),t("li",[t("code",[s._v("limit")]),s._v(": 替换次数，大于等于 -1 的整数，默认为 -1 表示所有匹配的子串都会被替换。")]),s._v(" "),t("li",[t("code",[s._v("offset")]),s._v(": 需要跳过的匹配次数，即前"),t("code",[s._v("offset")]),s._v("次匹配到的字符子串并不会被替换，默认为 0。")]),s._v(" "),t("li",[t("code",[s._v("reverse")]),s._v(": 是否需要反向计数，默认为 false 即按照从左向右的次序。")])]),s._v(" "),t("p",[t("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为 TEXT。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-11"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-11"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+---------------+\n| Time|root.test.d1.s1|\n+-----------------------------+---------------+\n|2021-01-01T00:00:01.000+08:00| A,B,A+,B-|\n|2021-01-01T00:00:02.000+08:00| A,A+,A,B+|\n|2021-01-01T00:00:03.000+08:00| B+,B,B|\n|2021-01-01T00:00:04.000+08:00| A+,A,A+,A|\n|2021-01-01T00:00:05.000+08:00| A,B-,B,B|\n+-----------------------------+---------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br"),t("span",{staticClass:"line-number"},[s._v("9")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句：")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" strreplace"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"target"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('","')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"replace"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"/"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"limit"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"2"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+-----------------------------------------+\n| Time|strreplace(root.test.d1.s1, "target"=",",|\n| | "replace"="/", "limit"="2")|\n+-----------------------------+-----------------------------------------+\n|2021-01-01T00:00:01.000+08:00| A/B/A+,B-|\n|2021-01-01T00:00:02.000+08:00| A/A+/A,B+|\n|2021-01-01T00:00:03.000+08:00| B+/B/B|\n|2021-01-01T00:00:04.000+08:00| A+/A/A+,A|\n|2021-01-01T00:00:05.000+08:00| A/B-/B,B|\n+-----------------------------+-----------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br"),t("span",{staticClass:"line-number"},[s._v("9")]),t("br"),t("span",{staticClass:"line-number"},[s._v("10")]),t("br")])]),t("p",[s._v("另一个用于查询的 SQL 语句：")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" strreplace"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"target"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('","')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"replace"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"/"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"limit"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"1"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"offset"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"1"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"reverse"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"true"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+-----------------------------------------------------+\n| Time|strreplace(root.test.d1.s1, "target"=",", "replace"= | \n| | "|", "limit"="1", "offset"="1", "reverse"="true")|\n+-----------------------------+-----------------------------------------------------+\n|2021-01-01T00:00:01.000+08:00| A,B/A+,B-|\n|2021-01-01T00:00:02.000+08:00| A,A+/A,B+|\n|2021-01-01T00:00:03.000+08:00| B+/B,B|\n|2021-01-01T00:00:04.000+08:00| A+,A/A+,A|\n|2021-01-01T00:00:05.000+08:00| A,B-/B,B|\n+-----------------------------+-----------------------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br"),t("span",{staticClass:"line-number"},[s._v("9")]),t("br"),t("span",{staticClass:"line-number"},[s._v("10")]),t("br")])]),t("h2",{attrs:{id:"regexmatch"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#regexmatch"}},[s._v("#")]),s._v(" RegexMatch")]),s._v(" "),t("h3",{attrs:{id:"函数简介-12"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-12"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于正则表达式匹配文本中的具体内容并返回。")]),s._v(" "),t("p",[t("strong",[s._v("函数名：")]),s._v(" REGEXMATCH")]),s._v(" "),t("p",[t("strong",[s._v("输入序列：")]),s._v(" 仅支持单个输入序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("参数：")])]),s._v(" "),t("ul",[t("li",[t("code",[s._v("regex")]),s._v(": 匹配的正则表达式，支持所有 Java 正则表达式语法，比如"),t("code",[s._v("\\d+\\.\\d+\\.\\d+\\.\\d+")]),s._v("将会匹配任意 IPv4 地址.")]),s._v(" "),t("li",[t("code",[s._v("group")]),s._v(": 输出的匹配组序号，根据 java.util.regex 规定，第 0 组为整个正则表达式，此后的组按照左括号出现的顺序依次编号。\n如"),t("code",[s._v("A(B(CD))")]),s._v("中共有三个组，第 0 组"),t("code",[s._v("A(B(CD))")]),s._v("，第 1 组"),t("code",[s._v("B(CD)")]),s._v("和第 2 组"),t("code",[s._v("CD")]),s._v("。")])]),s._v(" "),t("p",[t("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("提示：")]),s._v(" 空值或无法匹配给定的正则表达式的数据点没有输出结果。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-12"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-12"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+-------------------------------+\n| Time| root.test.d1.s1|\n+-----------------------------+-------------------------------+\n|2021-01-01T00:00:01.000+08:00| [192.168.0.1] [SUCCESS]|\n|2021-01-01T00:00:02.000+08:00| [192.168.0.24] [SUCCESS]|\n|2021-01-01T00:00:03.000+08:00| [192.168.0.2] [FAIL]|\n|2021-01-01T00:00:04.000+08:00| [192.168.0.5] [SUCCESS]|\n|2021-01-01T00:00:05.000+08:00| [192.168.0.124] [SUCCESS]|\n+-----------------------------+-------------------------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br"),t("span",{staticClass:"line-number"},[s._v("9")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句：")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" regexmatch"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"regex"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"\\d+\\.\\d+\\.\\d+\\.\\d+"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"group"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"0"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+----------------------------------------------------------------------+\n| Time|regexmatch(root.test.d1.s1, "regex"="\\d+\\.\\d+\\.\\d+\\.\\d+", "group"="0")|\n+-----------------------------+----------------------------------------------------------------------+\n|2021-01-01T00:00:01.000+08:00| 192.168.0.1|\n|2021-01-01T00:00:02.000+08:00| 192.168.0.24|\n|2021-01-01T00:00:03.000+08:00| 192.168.0.2|\n|2021-01-01T00:00:04.000+08:00| 192.168.0.5|\n|2021-01-01T00:00:05.000+08:00| 192.168.0.124|\n+-----------------------------+----------------------------------------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br"),t("span",{staticClass:"line-number"},[s._v("9")]),t("br")])]),t("h2",{attrs:{id:"regexreplace"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#regexreplace"}},[s._v("#")]),s._v(" RegexReplace")]),s._v(" "),t("h3",{attrs:{id:"函数简介-13"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-13"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于将文本中符合正则表达式的匹配结果替换为指定的字符串。")]),s._v(" "),t("p",[t("strong",[s._v("函数名：")]),s._v(" REGEXREPLACE")]),s._v(" "),t("p",[t("strong",[s._v("输入序列：")]),s._v(" 仅支持单个输入序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("参数：")])]),s._v(" "),t("ul",[t("li",[t("code",[s._v("regex")]),s._v(": 需要替换的正则表达式，支持所有 Java 正则表达式语法。")]),s._v(" "),t("li",[t("code",[s._v("replace")]),s._v(": 替换后的字符串，支持 Java 正则表达式中的后向引用，\n形如'$1'指代了正则表达式"),t("code",[s._v("regex")]),s._v("中的第一个分组，并会在替换时自动填充匹配到的子串。")]),s._v(" "),t("li",[t("code",[s._v("limit")]),s._v(": 替换次数，大于等于 -1 的整数，默认为 -1 表示所有匹配的子串都会被替换。")]),s._v(" "),t("li",[t("code",[s._v("offset")]),s._v(": 需要跳过的匹配次数，即前"),t("code",[s._v("offset")]),s._v("次匹配到的字符子串并不会被替换，默认为 0。")]),s._v(" "),t("li",[t("code",[s._v("reverse")]),s._v(": 是否需要反向计数，默认为 false 即按照从左向右的次序。")])]),s._v(" "),t("p",[t("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为 TEXT。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-13"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-13"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+-------------------------------+\n| Time| root.test.d1.s1|\n+-----------------------------+-------------------------------+\n|2021-01-01T00:00:01.000+08:00| [192.168.0.1] [SUCCESS]|\n|2021-01-01T00:00:02.000+08:00| [192.168.0.24] [SUCCESS]|\n|2021-01-01T00:00:03.000+08:00| [192.168.0.2] [FAIL]|\n|2021-01-01T00:00:04.000+08:00| [192.168.0.5] [SUCCESS]|\n|2021-01-01T00:00:05.000+08:00| [192.168.0.124] [SUCCESS]|\n+-----------------------------+-------------------------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br"),t("span",{staticClass:"line-number"},[s._v("9")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句：")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" regexreplace"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"regex"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"192\\.168\\.0\\.(\\d+)"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"replace"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"cluster-$1"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"limit"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"1"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+-----------------------------------------------------------+\n| Time|regexreplace(root.test.d1.s1, "regex"="192\\.168\\.0\\.(\\d+)",|\n| | "replace"="cluster-$1", "limit"="1")|\n+-----------------------------+-----------------------------------------------------------+\n|2021-01-01T00:00:01.000+08:00| [cluster-1] [SUCCESS]|\n|2021-01-01T00:00:02.000+08:00| [cluster-24] [SUCCESS]|\n|2021-01-01T00:00:03.000+08:00| [cluster-2] [FAIL]|\n|2021-01-01T00:00:04.000+08:00| [cluster-5] [SUCCESS]|\n|2021-01-01T00:00:05.000+08:00| [cluster-124] [SUCCESS]|\n+-----------------------------+-----------------------------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br"),t("span",{staticClass:"line-number"},[s._v("9")]),t("br"),t("span",{staticClass:"line-number"},[s._v("10")]),t("br")])]),t("h2",{attrs:{id:"regexsplit"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#regexsplit"}},[s._v("#")]),s._v(" RegexSplit")]),s._v(" "),t("h3",{attrs:{id:"函数简介-14"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-14"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于使用给定的正则表达式切分文本，并返回指定的项。")]),s._v(" "),t("p",[t("strong",[s._v("函数名：")]),s._v(" REGEXSPLIT")]),s._v(" "),t("p",[t("strong",[s._v("输入序列：")]),s._v(" 仅支持单个输入序列，类型为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("参数：")])]),s._v(" "),t("ul",[t("li",[t("code",[s._v("regex")]),s._v(": 用于分割文本的正则表达式，支持所有 Java 正则表达式语法，比如"),t("code",[s._v("['\"]")]),s._v("将会匹配任意的英文引号"),t("code",[s._v("'")]),s._v("和"),t("code",[s._v('"')]),s._v("。")]),s._v(" "),t("li",[t("code",[s._v("index")]),s._v(": 输出结果在切分后数组中的序号，需要是大于等于 -1 的整数，默认值为 -1 表示返回切分后数组的长度，其它非负整数即表示返回数组中对应位置的切分结果（数组的秩从 0 开始计数）。")])]),s._v(" "),t("p",[t("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，在"),t("code",[s._v("index")]),s._v("为 -1 时输出数据类型为 INT32，否则为 TEXT。")]),s._v(" "),t("p",[t("strong",[s._v("提示：")]),s._v(" 如果"),t("code",[s._v("index")]),s._v("超出了切分后结果数组的秩范围，例如使用"),t("code",[s._v(",")]),s._v("切分"),t("code",[s._v("0,1,2")]),s._v("时输入"),t("code",[s._v("index")]),s._v("为 3，则该数据点没有输出结果。")]),s._v(" "),t("h3",{attrs:{id:"使用示例-14"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-14"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("输入序列：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+---------------+\n| Time|root.test.d1.s1|\n+-----------------------------+---------------+\n|2021-01-01T00:00:01.000+08:00| A,B,A+,B-|\n|2021-01-01T00:00:02.000+08:00| A,A+,A,B+|\n|2021-01-01T00:00:03.000+08:00| B+,B,B|\n|2021-01-01T00:00:04.000+08:00| A+,A,A+,A|\n|2021-01-01T00:00:05.000+08:00| A,B-,B,B|\n+-----------------------------+---------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br"),t("span",{staticClass:"line-number"},[s._v("9")]),t("br")])]),t("p",[s._v("用于查询的 SQL 语句：")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" regexsplit"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"regex"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('","')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"index"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"-1"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+------------------------------------------------------+\n| Time|regexsplit(root.test.d1.s1, "regex"=",", "index"="-1")|\n+-----------------------------+------------------------------------------------------+\n|2021-01-01T00:00:01.000+08:00| 4|\n|2021-01-01T00:00:02.000+08:00| 4|\n|2021-01-01T00:00:03.000+08:00| 3|\n|2021-01-01T00:00:04.000+08:00| 4|\n|2021-01-01T00:00:05.000+08:00| 4|\n+-----------------------------+------------------------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br"),t("span",{staticClass:"line-number"},[s._v("9")]),t("br")])]),t("p",[s._v("另一个查询的 SQL 语句：")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" regexsplit"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"regex"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('","')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"index"')]),t("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),t("span",{pre:!0,attrs:{class:"token string"}},[s._v('"3"')]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("输出序列：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v('+-----------------------------+-----------------------------------------------------+\n| Time|regexsplit(root.test.d1.s1, "regex"=",", "index"="3")|\n+-----------------------------+-----------------------------------------------------+\n|2021-01-01T00:00:01.000+08:00| B-|\n|2021-01-01T00:00:02.000+08:00| B+|\n|2021-01-01T00:00:04.000+08:00| A|\n|2021-01-01T00:00:05.000+08:00| B|\n+-----------------------------+-----------------------------------------------------+\n')])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br")])])])}),[],!1,null,null,null);t.default=e.exports}}]); |