| (window.webpackJsonp=window.webpackJsonp||[]).push([[543],{941:function(s,a,n){"use strict";n.r(a);var t=n(29),e=Object(t.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("h2",{attrs:{id:"iqr"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#iqr"}},[s._v("#")]),s._v(" IQR")]),s._v(" "),a("h3",{attrs:{id:"函数简介"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#函数简介"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),a("p",[s._v("本函数用于检验超出上下四分位数1.5倍IQR的数据分布异常。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" IQR")]),s._v(" "),a("p",[a("strong",[s._v("输入序列：")]),s._v(" 仅支持单个输入序列，类型为 INT32 / INT64 / FLOAT / DOUBLE。")]),s._v(" "),a("p",[a("strong",[s._v("参数：")])]),s._v(" "),a("ul",[a("li",[a("code",[s._v("method")]),s._v('：若设置为 "batch"，则将数据全部读入后检测；若设置为 "stream"，则需用户提供上下四分位数进行流式检测。默认为 "batch"。')]),s._v(" "),a("li",[a("code",[s._v("q1")]),s._v("：使用流式计算时的下四分位数。")]),s._v(" "),a("li",[a("code",[s._v("q3")]),s._v("：使用流式计算时的上四分位数。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列")]),s._v("：输出单个序列，类型为 DOUBLE。")]),s._v(" "),a("p",[a("strong",[s._v("说明")]),s._v("：$IQR=Q_3-Q_1$")]),s._v(" "),a("h3",{attrs:{id:"使用示例"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#使用示例"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),a("h4",{attrs:{id:"全数据计算"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#全数据计算"}},[s._v("#")]),s._v(" 全数据计算")]),s._v(" "),a("p",[s._v("输入序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+------------+\n| Time|root.test.s1|\n+-----------------------------+------------+\n|1970-01-01T08:00:00.100+08:00| 0.0|\n|1970-01-01T08:00:00.200+08:00| 0.0|\n|1970-01-01T08:00:00.300+08:00| 1.0|\n|1970-01-01T08:00:00.400+08:00| -1.0|\n|1970-01-01T08:00:00.500+08:00| 0.0|\n|1970-01-01T08:00:00.600+08:00| 0.0|\n|1970-01-01T08:00:00.700+08:00| -2.0|\n|1970-01-01T08:00:00.800+08:00| 2.0|\n|1970-01-01T08:00:00.900+08:00| 0.0|\n|1970-01-01T08:00:01.000+08:00| 0.0|\n|1970-01-01T08:00:01.100+08:00| 1.0|\n|1970-01-01T08:00:01.200+08:00| -1.0|\n|1970-01-01T08:00:01.300+08:00| -1.0|\n|1970-01-01T08:00:01.400+08:00| 1.0|\n|1970-01-01T08:00:01.500+08:00| 0.0|\n|1970-01-01T08:00:01.600+08:00| 0.0|\n|1970-01-01T08:00:01.700+08:00| 10.0|\n|1970-01-01T08:00:01.800+08:00| 2.0|\n|1970-01-01T08:00:01.900+08:00| -2.0|\n|1970-01-01T08:00:02.000+08:00| 0.0|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br"),a("span",{staticClass:"line-number"},[s._v("13")]),a("br"),a("span",{staticClass:"line-number"},[s._v("14")]),a("br"),a("span",{staticClass:"line-number"},[s._v("15")]),a("br"),a("span",{staticClass:"line-number"},[s._v("16")]),a("br"),a("span",{staticClass:"line-number"},[s._v("17")]),a("br"),a("span",{staticClass:"line-number"},[s._v("18")]),a("br"),a("span",{staticClass:"line-number"},[s._v("19")]),a("br"),a("span",{staticClass:"line-number"},[s._v("20")]),a("br"),a("span",{staticClass:"line-number"},[s._v("21")]),a("br"),a("span",{staticClass:"line-number"},[s._v("22")]),a("br"),a("span",{staticClass:"line-number"},[s._v("23")]),a("br"),a("span",{staticClass:"line-number"},[s._v("24")]),a("br")])]),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("select")]),s._v(" iqr"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test\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- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+-----------------+\n| Time|iqr(root.test.s1)|\n+-----------------------------+-----------------+\n|1970-01-01T08:00:01.700+08:00| 10.0|\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:"ksigma"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#ksigma"}},[s._v("#")]),s._v(" KSigma")]),s._v(" "),a("h3",{attrs:{id:"函数简介-2"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-2"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),a("p",[s._v("本函数利用动态 K-Sigma 算法进行异常检测。在一个窗口内，与平均值的差距超过k倍标准差的数据将被视作异常并输出。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" KSIGMA")]),s._v(" "),a("p",[a("strong",[s._v("输入序列：")]),s._v(" 仅支持单个输入序列，类型为 INT32 / INT64 / FLOAT / DOUBLE")]),s._v(" "),a("p",[a("strong",[s._v("参数：")])]),s._v(" "),a("ul",[a("li",[a("code",[s._v("k")]),s._v("：在动态 K-Sigma 算法中，分布异常的标准差倍数阈值，默认值为 3。")]),s._v(" "),a("li",[a("code",[s._v("window")]),s._v("：动态 K-Sigma 算法的滑动窗口大小，默认值为 10000。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型与输入序列相同。")]),s._v(" "),a("p",[a("strong",[s._v("提示：")]),s._v(" k 应大于 0，否则将不做输出。")]),s._v(" "),a("h3",{attrs:{id:"使用示例-2"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-2"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),a("h4",{attrs:{id:"指定k"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#指定k"}},[s._v("#")]),s._v(" 指定k")]),s._v(" "),a("p",[s._v("输入序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+---------------+\n| Time|root.test.d1.s1|\n+-----------------------------+---------------+\n|2020-01-01T00:00:02.000+08:00| 0.0|\n|2020-01-01T00:00:03.000+08:00| 50.0|\n|2020-01-01T00:00:04.000+08:00| 100.0|\n|2020-01-01T00:00:06.000+08:00| 150.0|\n|2020-01-01T00:00:08.000+08:00| 200.0|\n|2020-01-01T00:00:10.000+08:00| 200.0|\n|2020-01-01T00:00:14.000+08:00| 200.0|\n|2020-01-01T00:00:15.000+08:00| 200.0|\n|2020-01-01T00:00:16.000+08:00| 200.0|\n|2020-01-01T00:00:18.000+08:00| 200.0|\n|2020-01-01T00:00:20.000+08:00| 150.0|\n|2020-01-01T00:00:22.000+08:00| 100.0|\n|2020-01-01T00:00:26.000+08:00| 50.0|\n|2020-01-01T00:00:28.000+08:00| 0.0|\n|2020-01-01T00:00:30.000+08:00| NaN|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br"),a("span",{staticClass:"line-number"},[s._v("13")]),a("br"),a("span",{staticClass:"line-number"},[s._v("14")]),a("br"),a("span",{staticClass:"line-number"},[s._v("15")]),a("br"),a("span",{staticClass:"line-number"},[s._v("16")]),a("br"),a("span",{staticClass:"line-number"},[s._v("17")]),a("br"),a("span",{staticClass:"line-number"},[s._v("18")]),a("br"),a("span",{staticClass:"line-number"},[s._v("19")]),a("br")])]),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("select")]),s._v(" ksigma"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v('"k"')]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v('"1.0"')]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1 "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("where")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("time")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("<=")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("2020")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("-")]),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("01")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("-")]),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("01")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("00")]),s._v(":"),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("00")]),s._v(":"),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("30")]),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("输出序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v('+-----------------------------+---------------------------------+\n|Time |ksigma(root.test.d1.s1,"k"="3.0")|\n+-----------------------------+---------------------------------+\n|2020-01-01T00:00:02.000+08:00| 0.0|\n|2020-01-01T00:00:03.000+08:00| 50.0|\n|2020-01-01T00:00:26.000+08:00| 50.0|\n|2020-01-01T00:00:28.000+08:00| 0.0|\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("h2",{attrs:{id:"lof"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#lof"}},[s._v("#")]),s._v(" LOF")]),s._v(" "),a("h3",{attrs:{id:"函数简介-3"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-3"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),a("p",[s._v("本函数使用局部离群点检测方法用于查找序列的密度异常。将根据提供的第k距离数及局部离群点因子(lof)阈值，判断输入数据是否为离群点，即异常，并输出各点的 LOF 值。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" LOF")]),s._v(" "),a("p",[a("strong",[s._v("输入序列：")]),s._v(" 多个输入序列，类型为 INT32 / INT64 / FLOAT / DOUBLE")]),s._v(" "),a("p",[a("strong",[s._v("参数：")])]),s._v(" "),a("ul",[a("li",[a("code",[s._v("method")]),s._v(":使用的检测方法。默认为 default，以高维数据计算。设置为 series，将一维时间序列转换为高维数据计算。")]),s._v(" "),a("li",[a("code",[s._v("k")]),s._v(":使用第k距离计算局部离群点因子.默认为 3。")]),s._v(" "),a("li",[a("code",[s._v("window")]),s._v(":每次读取数据的窗口长度。默认为 10000.")]),s._v(" "),a("li",[a("code",[s._v("windowsize")]),s._v(":使用series方法时，转化高维数据的维数，即单个窗口的大小。默认为 5。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单时间序列，类型为DOUBLE。")]),s._v(" "),a("p",[a("strong",[s._v("提示：")]),s._v(" 不完整的数据行会被忽略，不参与计算，也不标记为离群点。")]),s._v(" "),a("h3",{attrs:{id:"使用示例-3"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-3"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),a("h4",{attrs:{id:"默认参数"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#默认参数"}},[s._v("#")]),s._v(" 默认参数")]),s._v(" "),a("p",[s._v("输入序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+---------------+---------------+\n| Time|root.test.d1.s1|root.test.d1.s2|\n+-----------------------------+---------------+---------------+\n|1970-01-01T08:00:00.100+08:00| 0.0| 0.0|\n|1970-01-01T08:00:00.200+08:00| 0.0| 1.0|\n|1970-01-01T08:00:00.300+08:00| 1.0| 1.0|\n|1970-01-01T08:00:00.400+08:00| 1.0| 0.0|\n|1970-01-01T08:00:00.500+08:00| 0.0| -1.0|\n|1970-01-01T08:00:00.600+08:00| -1.0| -1.0|\n|1970-01-01T08:00:00.700+08:00| -1.0| 0.0|\n|1970-01-01T08:00:00.800+08:00| 2.0| 2.0|\n|1970-01-01T08:00:00.900+08:00| 0.0| null|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br"),a("span",{staticClass:"line-number"},[s._v("13")]),a("br")])]),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("select")]),s._v(" lof"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v("s2"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1 "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("where")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("time")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("<")]),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("1000")]),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("输出序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+-------------------------------------+\n| Time|lof(root.test.d1.s1, root.test.d1.s2)|\n+-----------------------------+-------------------------------------+\n|1970-01-01T08:00:00.100+08:00| 3.8274824267668244|\n|1970-01-01T08:00:00.200+08:00| 3.0117631741126156|\n|1970-01-01T08:00:00.300+08:00| 2.838155437762879|\n|1970-01-01T08:00:00.400+08:00| 3.0117631741126156|\n|1970-01-01T08:00:00.500+08:00| 2.73518261244453|\n|1970-01-01T08:00:00.600+08:00| 2.371440975708148|\n|1970-01-01T08:00:00.700+08:00| 2.73518261244453|\n|1970-01-01T08:00:00.800+08:00| 1.7561416374270742|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br")])]),a("h4",{attrs:{id:"诊断一维时间序列"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#诊断一维时间序列"}},[s._v("#")]),s._v(" 诊断一维时间序列")]),s._v(" "),a("p",[s._v("输入序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+---------------+\n| Time|root.test.d1.s1|\n+-----------------------------+---------------+\n|1970-01-01T08:00:00.100+08:00| 1.0|\n|1970-01-01T08:00:00.200+08:00| 2.0|\n|1970-01-01T08:00:00.300+08:00| 3.0|\n|1970-01-01T08:00:00.400+08:00| 4.0|\n|1970-01-01T08:00:00.500+08:00| 5.0|\n|1970-01-01T08:00:00.600+08:00| 6.0|\n|1970-01-01T08:00:00.700+08:00| 7.0|\n|1970-01-01T08:00:00.800+08:00| 8.0|\n|1970-01-01T08:00:00.900+08:00| 9.0|\n|1970-01-01T08:00:01.000+08:00| 10.0|\n|1970-01-01T08:00:01.100+08:00| 11.0|\n|1970-01-01T08:00:01.200+08:00| 12.0|\n|1970-01-01T08:00:01.300+08:00| 13.0|\n|1970-01-01T08:00:01.400+08:00| 14.0|\n|1970-01-01T08:00:01.500+08:00| 15.0|\n|1970-01-01T08:00:01.600+08:00| 16.0|\n|1970-01-01T08:00:01.700+08:00| 17.0|\n|1970-01-01T08:00:01.800+08:00| 18.0|\n|1970-01-01T08:00:01.900+08:00| 19.0|\n|1970-01-01T08:00:02.000+08:00| 20.0|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br"),a("span",{staticClass:"line-number"},[s._v("13")]),a("br"),a("span",{staticClass:"line-number"},[s._v("14")]),a("br"),a("span",{staticClass:"line-number"},[s._v("15")]),a("br"),a("span",{staticClass:"line-number"},[s._v("16")]),a("br"),a("span",{staticClass:"line-number"},[s._v("17")]),a("br"),a("span",{staticClass:"line-number"},[s._v("18")]),a("br"),a("span",{staticClass:"line-number"},[s._v("19")]),a("br"),a("span",{staticClass:"line-number"},[s._v("20")]),a("br"),a("span",{staticClass:"line-number"},[s._v("21")]),a("br"),a("span",{staticClass:"line-number"},[s._v("22")]),a("br"),a("span",{staticClass:"line-number"},[s._v("23")]),a("br"),a("span",{staticClass:"line-number"},[s._v("24")]),a("br")])]),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("select")]),s._v(" lof"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token string"}},[s._v('"method"')]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v('"series"')]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1 "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("where")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("time")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("<")]),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("1000")]),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("输出序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+--------------------+\n| Time|lof(root.test.d1.s1)|\n+-----------------------------+--------------------+\n|1970-01-01T08:00:00.100+08:00| 3.77777777777778|\n|1970-01-01T08:00:00.200+08:00| 4.32727272727273|\n|1970-01-01T08:00:00.300+08:00| 4.85714285714286|\n|1970-01-01T08:00:00.400+08:00| 5.40909090909091|\n|1970-01-01T08:00:00.500+08:00| 5.94999999999999|\n|1970-01-01T08:00:00.600+08:00| 6.43243243243243|\n|1970-01-01T08:00:00.700+08:00| 6.79999999999999|\n|1970-01-01T08:00:00.800+08:00| 7.0|\n|1970-01-01T08:00:00.900+08:00| 7.0|\n|1970-01-01T08:00:01.000+08:00| 6.79999999999999|\n|1970-01-01T08:00:01.100+08:00| 6.43243243243243|\n|1970-01-01T08:00:01.200+08:00| 5.94999999999999|\n|1970-01-01T08:00:01.300+08:00| 5.40909090909091|\n|1970-01-01T08:00:01.400+08:00| 4.85714285714286|\n|1970-01-01T08:00:01.500+08:00| 4.32727272727273|\n|1970-01-01T08:00:01.600+08:00| 3.77777777777778|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br"),a("span",{staticClass:"line-number"},[s._v("13")]),a("br"),a("span",{staticClass:"line-number"},[s._v("14")]),a("br"),a("span",{staticClass:"line-number"},[s._v("15")]),a("br"),a("span",{staticClass:"line-number"},[s._v("16")]),a("br"),a("span",{staticClass:"line-number"},[s._v("17")]),a("br"),a("span",{staticClass:"line-number"},[s._v("18")]),a("br"),a("span",{staticClass:"line-number"},[s._v("19")]),a("br"),a("span",{staticClass:"line-number"},[s._v("20")]),a("br")])]),a("h2",{attrs:{id:"missdetect"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#missdetect"}},[s._v("#")]),s._v(" MissDetect")]),s._v(" "),a("h3",{attrs:{id:"函数简介-4"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-4"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),a("p",[s._v("本函数用于检测数据中的缺失异常。在一些数据中，缺失数据会被线性插值填补，在数据中出现完美的线性片段，且这些片段往往长度较大。本函数通过在数据中发现这些完美线性片段来检测缺失异常。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" MISSDETECT")]),s._v(" "),a("p",[a("strong",[s._v("输入序列：")]),s._v(" 仅支持单个输入序列，类型为 INT32 / INT64 / FLOAT / DOUBLE。")]),s._v(" "),a("p",[a("strong",[s._v("参数：")])]),s._v(" "),a("ul",[a("li",[a("code",[s._v("minlen")]),s._v("：被标记为异常的完美线性片段的最小长度，是一个大于等于 10 的整数，默认值为 10。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为 BOOLEAN，即该数据点是否为缺失异常。")]),s._v(" "),a("p",[a("strong",[s._v("提示：")]),s._v(" 数据中的"),a("code",[s._v("NaN")]),s._v("将会被忽略。")]),s._v(" "),a("h3",{attrs:{id:"使用示例-4"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-4"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),a("p",[s._v("输入序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+---------------+\n| Time|root.test.d2.s2|\n+-----------------------------+---------------+\n|2021-07-01T12:00:00.000+08:00| 0.0|\n|2021-07-01T12:00:01.000+08:00| 1.0|\n|2021-07-01T12:00:02.000+08:00| 0.0|\n|2021-07-01T12:00:03.000+08:00| 1.0|\n|2021-07-01T12:00:04.000+08:00| 0.0|\n|2021-07-01T12:00:05.000+08:00| 0.0|\n|2021-07-01T12:00:06.000+08:00| 0.0|\n|2021-07-01T12:00:07.000+08:00| 0.0|\n|2021-07-01T12:00:08.000+08:00| 0.0|\n|2021-07-01T12:00:09.000+08:00| 0.0|\n|2021-07-01T12:00:10.000+08:00| 0.0|\n|2021-07-01T12:00:11.000+08:00| 0.0|\n|2021-07-01T12:00:12.000+08:00| 0.0|\n|2021-07-01T12:00:13.000+08:00| 0.0|\n|2021-07-01T12:00:14.000+08:00| 0.0|\n|2021-07-01T12:00:15.000+08:00| 0.0|\n|2021-07-01T12:00:16.000+08:00| 1.0|\n|2021-07-01T12:00:17.000+08:00| 0.0|\n|2021-07-01T12:00:18.000+08:00| 1.0|\n|2021-07-01T12:00:19.000+08:00| 0.0|\n|2021-07-01T12:00:20.000+08:00| 1.0|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br"),a("span",{staticClass:"line-number"},[s._v("13")]),a("br"),a("span",{staticClass:"line-number"},[s._v("14")]),a("br"),a("span",{staticClass:"line-number"},[s._v("15")]),a("br"),a("span",{staticClass:"line-number"},[s._v("16")]),a("br"),a("span",{staticClass:"line-number"},[s._v("17")]),a("br"),a("span",{staticClass:"line-number"},[s._v("18")]),a("br"),a("span",{staticClass:"line-number"},[s._v("19")]),a("br"),a("span",{staticClass:"line-number"},[s._v("20")]),a("br"),a("span",{staticClass:"line-number"},[s._v("21")]),a("br"),a("span",{staticClass:"line-number"},[s._v("22")]),a("br"),a("span",{staticClass:"line-number"},[s._v("23")]),a("br"),a("span",{staticClass:"line-number"},[s._v("24")]),a("br"),a("span",{staticClass:"line-number"},[s._v("25")]),a("br")])]),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("select")]),s._v(" missdetect"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s2"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'minlen'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'10'")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d2\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- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v('+-----------------------------+------------------------------------------+\n| Time|missdetect(root.test.d2.s2, "minlen"="10")|\n+-----------------------------+------------------------------------------+\n|2021-07-01T12:00:00.000+08:00| false|\n|2021-07-01T12:00:01.000+08:00| false|\n|2021-07-01T12:00:02.000+08:00| false|\n|2021-07-01T12:00:03.000+08:00| false|\n|2021-07-01T12:00:04.000+08:00| true|\n|2021-07-01T12:00:05.000+08:00| true|\n|2021-07-01T12:00:06.000+08:00| true|\n|2021-07-01T12:00:07.000+08:00| true|\n|2021-07-01T12:00:08.000+08:00| true|\n|2021-07-01T12:00:09.000+08:00| true|\n|2021-07-01T12:00:10.000+08:00| true|\n|2021-07-01T12:00:11.000+08:00| true|\n|2021-07-01T12:00:12.000+08:00| true|\n|2021-07-01T12:00:13.000+08:00| true|\n|2021-07-01T12:00:14.000+08:00| true|\n|2021-07-01T12:00:15.000+08:00| true|\n|2021-07-01T12:00:16.000+08:00| false|\n|2021-07-01T12:00:17.000+08:00| false|\n|2021-07-01T12:00:18.000+08:00| false|\n|2021-07-01T12:00:19.000+08:00| false|\n|2021-07-01T12:00:20.000+08:00| false|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br"),a("span",{staticClass:"line-number"},[s._v("13")]),a("br"),a("span",{staticClass:"line-number"},[s._v("14")]),a("br"),a("span",{staticClass:"line-number"},[s._v("15")]),a("br"),a("span",{staticClass:"line-number"},[s._v("16")]),a("br"),a("span",{staticClass:"line-number"},[s._v("17")]),a("br"),a("span",{staticClass:"line-number"},[s._v("18")]),a("br"),a("span",{staticClass:"line-number"},[s._v("19")]),a("br"),a("span",{staticClass:"line-number"},[s._v("20")]),a("br"),a("span",{staticClass:"line-number"},[s._v("21")]),a("br"),a("span",{staticClass:"line-number"},[s._v("22")]),a("br"),a("span",{staticClass:"line-number"},[s._v("23")]),a("br"),a("span",{staticClass:"line-number"},[s._v("24")]),a("br"),a("span",{staticClass:"line-number"},[s._v("25")]),a("br")])]),a("h2",{attrs:{id:"range"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#range"}},[s._v("#")]),s._v(" Range")]),s._v(" "),a("h3",{attrs:{id:"函数简介-5"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-5"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),a("p",[s._v("本函数用于查找时间序列的范围异常。将根据提供的上界与下界，判断输入数据是否越界，即异常，并输出所有异常点为新的时间序列。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" RANGE")]),s._v(" "),a("p",[a("strong",[s._v("输入序列：")]),s._v(" 仅支持单个输入序列，类型为 INT32 / INT64 / FLOAT / DOUBLE")]),s._v(" "),a("p",[a("strong",[s._v("参数：")])]),s._v(" "),a("ul",[a("li",[a("code",[s._v("lower_bound")]),s._v(":范围异常检测的下界。")]),s._v(" "),a("li",[a("code",[s._v("upper_bound")]),s._v(":范围异常检测的上界。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型与输入序列相同。")]),s._v(" "),a("p",[a("strong",[s._v("提示：")]),s._v(" 应满足"),a("code",[s._v("upper_bound")]),s._v("大于"),a("code",[s._v("lower_bound")]),s._v("，否则将不做输出。")]),s._v(" "),a("h3",{attrs:{id:"使用示例-5"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-5"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),a("h4",{attrs:{id:"指定上界与下界"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#指定上界与下界"}},[s._v("#")]),s._v(" 指定上界与下界")]),s._v(" "),a("p",[s._v("输入序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+---------------+\n| Time|root.test.d1.s1|\n+-----------------------------+---------------+\n|2020-01-01T00:00:02.000+08:00| 100.0|\n|2020-01-01T00:00:03.000+08:00| 101.0|\n|2020-01-01T00:00:04.000+08:00| 102.0|\n|2020-01-01T00:00:06.000+08:00| 104.0|\n|2020-01-01T00:00:08.000+08:00| 126.0|\n|2020-01-01T00:00:10.000+08:00| 108.0|\n|2020-01-01T00:00:14.000+08:00| 112.0|\n|2020-01-01T00:00:15.000+08:00| 113.0|\n|2020-01-01T00:00:16.000+08:00| 114.0|\n|2020-01-01T00:00:18.000+08:00| 116.0|\n|2020-01-01T00:00:20.000+08:00| 118.0|\n|2020-01-01T00:00:22.000+08:00| 120.0|\n|2020-01-01T00:00:26.000+08:00| 124.0|\n|2020-01-01T00:00:28.000+08:00| 126.0|\n|2020-01-01T00:00:30.000+08:00| NaN|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br"),a("span",{staticClass:"line-number"},[s._v("13")]),a("br"),a("span",{staticClass:"line-number"},[s._v("14")]),a("br"),a("span",{staticClass:"line-number"},[s._v("15")]),a("br"),a("span",{staticClass:"line-number"},[s._v("16")]),a("br"),a("span",{staticClass:"line-number"},[s._v("17")]),a("br"),a("span",{staticClass:"line-number"},[s._v("18")]),a("br"),a("span",{staticClass:"line-number"},[s._v("19")]),a("br")])]),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("select")]),s._v(" range"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v('"lower_bound"')]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v('"101.0"')]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v('"upper_bound"')]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v('"125.0"')]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1 "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("where")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("time")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("<=")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("2020")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("-")]),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("01")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("-")]),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("01")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("00")]),s._v(":"),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("00")]),s._v(":"),a("span",{pre:!0,attrs:{class:"token number"}},[s._v("30")]),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("输出序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v('+-----------------------------+------------------------------------------------------------------+\n|Time |range(root.test.d1.s1,"lower_bound"="101.0","upper_bound"="125.0")|\n+-----------------------------+------------------------------------------------------------------+\n|2020-01-01T00:00:02.000+08:00| 100.0|\n|2020-01-01T00:00:28.000+08:00| 126.0|\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:"twosidedfilter"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#twosidedfilter"}},[s._v("#")]),s._v(" TwoSidedFilter")]),s._v(" "),a("h3",{attrs:{id:"函数简介-6"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-6"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),a("p",[s._v("本函数基于双边窗口检测法对输入序列中的异常点进行过滤。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" TWOSIDEDFILTER")]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 仅支持单个输入序列，类型为 INT32 / INT64 / FLOAT / DOUBLE")]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型与输入相同，是输入序列去除异常点后的结果。")]),s._v(" "),a("p",[a("strong",[s._v("参数：")])]),s._v(" "),a("ul",[a("li",[a("code",[s._v("len")]),s._v("：双边窗口检测法中的窗口大小，取值范围为正整数，默认值为 5.如当"),a("code",[s._v("len")]),s._v("=3 时，算法向前、向后各取长度为3的窗口，在窗口中计算异常度。")]),s._v(" "),a("li",[a("code",[s._v("threshold")]),s._v("：异常度的阈值，取值范围为(0,1)，默认值为 0.3。阈值越高，函数对于异常度的判定标准越严格。")])]),s._v(" "),a("h3",{attrs:{id:"使用示例-6"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-6"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),a("p",[s._v("输入序列：")]),s._v(" "),a("div",{staticClass:"language- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+------------+\n| Time|root.test.s0|\n+-----------------------------+------------+\n|1970-01-01T08:00:00.000+08:00| 2002.0|\n|1970-01-01T08:00:01.000+08:00| 1946.0|\n|1970-01-01T08:00:02.000+08:00| 1958.0|\n|1970-01-01T08:00:03.000+08:00| 2012.0|\n|1970-01-01T08:00:04.000+08:00| 2051.0|\n|1970-01-01T08:00:05.000+08:00| 1898.0|\n|1970-01-01T08:00:06.000+08:00| 2014.0|\n|1970-01-01T08:00:07.000+08:00| 2052.0|\n|1970-01-01T08:00:08.000+08:00| 1935.0|\n|1970-01-01T08:00:09.000+08:00| 1901.0|\n|1970-01-01T08:00:10.000+08:00| 1972.0|\n|1970-01-01T08:00:11.000+08:00| 1969.0|\n|1970-01-01T08:00:12.000+08:00| 1984.0|\n|1970-01-01T08:00:13.000+08:00| 2018.0|\n|1970-01-01T08:00:37.000+08:00| 1484.0|\n|1970-01-01T08:00:38.000+08:00| 1055.0|\n|1970-01-01T08:00:39.000+08:00| 1050.0|\n|1970-01-01T08:01:05.000+08:00| 1023.0|\n|1970-01-01T08:01:06.000+08:00| 1056.0|\n|1970-01-01T08:01:07.000+08:00| 978.0|\n|1970-01-01T08:01:08.000+08:00| 1050.0|\n|1970-01-01T08:01:09.000+08:00| 1123.0|\n|1970-01-01T08:01:10.000+08:00| 1150.0|\n|1970-01-01T08:01:11.000+08:00| 1034.0|\n|1970-01-01T08:01:12.000+08:00| 950.0|\n|1970-01-01T08:01:13.000+08:00| 1059.0|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br"),a("span",{staticClass:"line-number"},[s._v("13")]),a("br"),a("span",{staticClass:"line-number"},[s._v("14")]),a("br"),a("span",{staticClass:"line-number"},[s._v("15")]),a("br"),a("span",{staticClass:"line-number"},[s._v("16")]),a("br"),a("span",{staticClass:"line-number"},[s._v("17")]),a("br"),a("span",{staticClass:"line-number"},[s._v("18")]),a("br"),a("span",{staticClass:"line-number"},[s._v("19")]),a("br"),a("span",{staticClass:"line-number"},[s._v("20")]),a("br"),a("span",{staticClass:"line-number"},[s._v("21")]),a("br"),a("span",{staticClass:"line-number"},[s._v("22")]),a("br"),a("span",{staticClass:"line-number"},[s._v("23")]),a("br"),a("span",{staticClass:"line-number"},[s._v("24")]),a("br"),a("span",{staticClass:"line-number"},[s._v("25")]),a("br"),a("span",{staticClass:"line-number"},[s._v("26")]),a("br"),a("span",{staticClass:"line-number"},[s._v("27")]),a("br"),a("span",{staticClass:"line-number"},[s._v("28")]),a("br"),a("span",{staticClass:"line-number"},[s._v("29")]),a("br"),a("span",{staticClass:"line-number"},[s._v("30")]),a("br")])]),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("select")]),s._v(" TwoSidedFilter"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s0"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'len'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'5'")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'threshold'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'0.3'")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("test\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- line-numbers-mode"},[a("pre",{pre:!0,attrs:{class:"language-text"}},[a("code",[s._v("+-----------------------------+------------+\n| Time|root.test.s0|\n+-----------------------------+------------+\n|1970-01-01T08:00:00.000+08:00| 2002.0|\n|1970-01-01T08:00:01.000+08:00| 1946.0|\n|1970-01-01T08:00:02.000+08:00| 1958.0|\n|1970-01-01T08:00:03.000+08:00| 2012.0|\n|1970-01-01T08:00:04.000+08:00| 2051.0|\n|1970-01-01T08:00:05.000+08:00| 1898.0|\n|1970-01-01T08:00:06.000+08:00| 2014.0|\n|1970-01-01T08:00:07.000+08:00| 2052.0|\n|1970-01-01T08:00:08.000+08:00| 1935.0|\n|1970-01-01T08:00:09.000+08:00| 1901.0|\n|1970-01-01T08:00:10.000+08:00| 1972.0|\n|1970-01-01T08:00:11.000+08:00| 1969.0|\n|1970-01-01T08:00:12.000+08:00| 1984.0|\n|1970-01-01T08:00:13.000+08:00| 2018.0|\n|1970-01-01T08:01:05.000+08:00| 1023.0|\n|1970-01-01T08:01:06.000+08:00| 1056.0|\n|1970-01-01T08:01:07.000+08:00| 978.0|\n|1970-01-01T08:01:08.000+08:00| 1050.0|\n|1970-01-01T08:01:09.000+08:00| 1123.0|\n|1970-01-01T08:01:10.000+08:00| 1150.0|\n|1970-01-01T08:01:11.000+08:00| 1034.0|\n|1970-01-01T08:01:12.000+08:00| 950.0|\n|1970-01-01T08:01:13.000+08:00| 1059.0|\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("span",{staticClass:"line-number"},[s._v("9")]),a("br"),a("span",{staticClass:"line-number"},[s._v("10")]),a("br"),a("span",{staticClass:"line-number"},[s._v("11")]),a("br"),a("span",{staticClass:"line-number"},[s._v("12")]),a("br"),a("span",{staticClass:"line-number"},[s._v("13")]),a("br"),a("span",{staticClass:"line-number"},[s._v("14")]),a("br"),a("span",{staticClass:"line-number"},[s._v("15")]),a("br"),a("span",{staticClass:"line-number"},[s._v("16")]),a("br"),a("span",{staticClass:"line-number"},[s._v("17")]),a("br"),a("span",{staticClass:"line-number"},[s._v("18")]),a("br"),a("span",{staticClass:"line-number"},[s._v("19")]),a("br"),a("span",{staticClass:"line-number"},[s._v("20")]),a("br"),a("span",{staticClass:"line-number"},[s._v("21")]),a("br"),a("span",{staticClass:"line-number"},[s._v("22")]),a("br"),a("span",{staticClass:"line-number"},[s._v("23")]),a("br"),a("span",{staticClass:"line-number"},[s._v("24")]),a("br"),a("span",{staticClass:"line-number"},[s._v("25")]),a("br"),a("span",{staticClass:"line-number"},[s._v("26")]),a("br"),a("span",{staticClass:"line-number"},[s._v("27")]),a("br")])])])}),[],!1,null,null,null);a.default=e.exports}}]); |