| (window.webpackJsonp=window.webpackJsonp||[]).push([[113],{510:function(s,a,n){"use strict";n.r(a);var e=n(29),t=Object(e.a)({},(function(){var s=this,a=s._self._c;return a("ContentSlotsDistributor",{attrs:{"slot-key":s.$parent.slotKey}},[a("h1",{attrs:{id:"anomaly-detection"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#anomaly-detection"}},[s._v("#")]),s._v(" Anomaly Detection")]),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:"usage"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#usage"}},[s._v("#")]),s._v(" Usage")]),s._v(" "),a("p",[s._v("This function is used to detect anomalies based on IQR. Points distributing beyond 1.5 times IQR are selected.")]),s._v(" "),a("p",[a("strong",[s._v("Name:")]),s._v(" IQR")]),s._v(" "),a("p",[a("strong",[s._v("Input Series:")]),s._v(" Only support a single input series. The type is INT32 / INT64 / FLOAT / DOUBLE.")]),s._v(" "),a("ul",[a("li",[a("code",[s._v("method")]),s._v(': When set to "batch", anomaly test is conducted after importing all data points; when set to "stream", it is required to provide upper and lower quantiles. The default method is "batch".')]),s._v(" "),a("li",[a("code",[s._v("q1")]),s._v(': The lower quantile when method is set to "stream".')]),s._v(" "),a("li",[a("code",[s._v("q3")]),s._v(': The upper quantile when method is set to "stream".')])]),s._v(" "),a("p",[a("strong",[s._v("Output Series:")]),s._v(" Output a single series. The type is DOUBLE.")]),s._v(" "),a("p",[a("strong",[s._v("Note:")]),s._v(" $IQR=Q_3-Q_1$")]),s._v(" "),a("h3",{attrs:{id:"examples"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#examples"}},[s._v("#")]),s._v(" Examples")]),s._v(" "),a("h4",{attrs:{id:"batch-computing"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#batch-computing"}},[s._v("#")]),s._v(" Batch computing")]),s._v(" "),a("p",[s._v("Input series:")]),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 for query:")]),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("Output series:")]),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:"usage-2"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#usage-2"}},[s._v("#")]),s._v(" Usage")]),s._v(" "),a("p",[s._v("This function is used to detect anomalies based on the Dynamic K-Sigma Algorithm.\nWithin a sliding window, the input value with a deviation of more than k times the standard deviation from the average will be output as anomaly.")]),s._v(" "),a("p",[a("strong",[s._v("Name:")]),s._v(" KSIGMA")]),s._v(" "),a("p",[a("strong",[s._v("Input Series:")]),s._v(" Only support a single input series. The type is INT32 / INT64 / FLOAT / DOUBLE.")]),s._v(" "),a("ul",[a("li",[a("code",[s._v("k")]),s._v(": How many times to multiply on standard deviation to define anomaly, the default value is 3.")]),s._v(" "),a("li",[a("code",[s._v("window")]),s._v(": The window size of Dynamic K-Sigma Algorithm, the default value is 10000.")])]),s._v(" "),a("p",[a("strong",[s._v("Output Series:")]),s._v(" Output a single series. The type is same as input series.")]),s._v(" "),a("p",[a("strong",[s._v("Note:")]),s._v(" Only when is larger than 0, the anomaly detection will be performed. Otherwise, nothing will be output.")]),s._v(" "),a("h3",{attrs:{id:"examples-2"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#examples-2"}},[s._v("#")]),s._v(" Examples")]),s._v(" "),a("h4",{attrs:{id:"assigning-k"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#assigning-k"}},[s._v("#")]),s._v(" Assigning k")]),s._v(" "),a("p",[s._v("Input series:")]),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 for query:")]),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("Output series:")]),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:"usage-3"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#usage-3"}},[s._v("#")]),s._v(" Usage")]),s._v(" "),a("p",[s._v("This function is used to detect density anomaly of time series. According to k-th distance calculation parameter and local outlier factor (lof) threshold, the function judges if a set of input values is an density anomaly, and a bool mark of anomaly values will be output.")]),s._v(" "),a("p",[a("strong",[s._v("Name:")]),s._v(" LOF")]),s._v(" "),a("p",[a("strong",[s._v("Input Series:")]),s._v(" Multiple input series. The type is INT32 / INT64 / FLOAT / DOUBLE.")]),s._v(" "),a("ul",[a("li",[a("code",[s._v("method")]),s._v(':assign a detection method. The default value is "default", when input data has multiple dimensions. The alternative is "series", when a input series will be transformed to high dimension.')]),s._v(" "),a("li",[a("code",[s._v("k")]),s._v(":use the k-th distance to calculate lof. Default value is 3.")]),s._v(" "),a("li",[a("code",[s._v("window")]),s._v(": size of window to split origin data points. Default value is 10000.")]),s._v(" "),a("li",[a("code",[s._v("windowsize")]),s._v(':dimension that will be transformed into when method is "series". The default value is 5.')])]),s._v(" "),a("p",[a("strong",[s._v("Output Series:")]),s._v(" Output a single series. The type is DOUBLE.")]),s._v(" "),a("p",[a("strong",[s._v("Note:")]),s._v(" Incomplete rows will be ignored. They are neither calculated nor marked as anomaly.")]),s._v(" "),a("h3",{attrs:{id:"examples-3"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#examples-3"}},[s._v("#")]),s._v(" Examples")]),s._v(" "),a("h4",{attrs:{id:"using-default-parameters"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#using-default-parameters"}},[s._v("#")]),s._v(" Using default parameters")]),s._v(" "),a("p",[s._v("Input series:")]),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 for query:")]),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("Output series:")]),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:"diagnosing-1d-timeseries"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#diagnosing-1d-timeseries"}},[s._v("#")]),s._v(" Diagnosing 1d timeseries")]),s._v(" "),a("p",[s._v("Input series:")]),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 for query:")]),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("Output series:")]),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:"usage-4"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#usage-4"}},[s._v("#")]),s._v(" Usage")]),s._v(" "),a("p",[s._v("This function is used to detect missing anomalies.\nIn some datasets, missing values are filled by linear interpolation.\nThus, there are several long perfect linear segments.\nBy discovering these perfect linear segments,\nmissing anomalies are detected.")]),s._v(" "),a("p",[a("strong",[s._v("Name:")]),s._v(" MISSDETECT")]),s._v(" "),a("p",[a("strong",[s._v("Input Series:")]),s._v(" Only support a single input series. The data type is INT32 / INT64 / FLOAT / DOUBLE.")]),s._v(" "),a("p",[a("strong",[s._v("Parameter:")])]),s._v(" "),a("p",[a("code",[s._v("error")]),s._v(": The minimum length of the detected missing anomalies, which is an integer greater than or equal to 10. By default, it is 10.")]),s._v(" "),a("p",[a("strong",[s._v("Output Series:")]),s._v(" Output a single series. The type is BOOLEAN. Each data point which is miss anomaly will be labeled as true.")]),s._v(" "),a("h3",{attrs:{id:"examples-4"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#examples-4"}},[s._v("#")]),s._v(" Examples")]),s._v(" "),a("p",[s._v("Input series:")]),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 for query:")]),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("Output series:")]),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:"usage-5"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#usage-5"}},[s._v("#")]),s._v(" Usage")]),s._v(" "),a("p",[s._v("This function is used to detect range anomaly of time series. According to upper bound and lower bound parameters, the function judges if a input value is beyond range, aka range anomaly, and a new time series of anomaly will be output.")]),s._v(" "),a("p",[a("strong",[s._v("Name:")]),s._v(" RANGE")]),s._v(" "),a("p",[a("strong",[s._v("Input Series:")]),s._v(" Only support a single input series. The type is INT32 / INT64 / FLOAT / DOUBLE.")]),s._v(" "),a("ul",[a("li",[a("code",[s._v("lower_bound")]),s._v(":lower bound of range anomaly detection.")]),s._v(" "),a("li",[a("code",[s._v("upper_bound")]),s._v(":upper bound of range anomaly detection.")])]),s._v(" "),a("p",[a("strong",[s._v("Output Series:")]),s._v(" Output a single series. The type is the same as the input.")]),s._v(" "),a("p",[a("strong",[s._v("Note:")]),s._v(" Only when "),a("code",[s._v("upper_bound")]),s._v(" is larger than "),a("code",[s._v("lower_bound")]),s._v(", the anomaly detection will be performed. Otherwise, nothing will be output.")]),s._v(" "),a("h3",{attrs:{id:"examples-5"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#examples-5"}},[s._v("#")]),s._v(" Examples")]),s._v(" "),a("h4",{attrs:{id:"assigning-lower-and-upper-bound"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#assigning-lower-and-upper-bound"}},[s._v("#")]),s._v(" Assigning Lower and Upper Bound")]),s._v(" "),a("p",[s._v("Input series:")]),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 for query:")]),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("Output series:")]),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:"usage-6"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#usage-6"}},[s._v("#")]),s._v(" Usage")]),s._v(" "),a("p",[s._v("The function is used to filter anomalies of a numeric time series based on two-sided window detection.")]),s._v(" "),a("p",[a("strong",[s._v("Name:")]),s._v(" TWOSIDEDFILTER")]),s._v(" "),a("p",[a("strong",[s._v("Input Series:")]),s._v(" Only support a single input series. The data type is INT32 / INT64 / FLOAT / DOUBLE")]),s._v(" "),a("p",[a("strong",[s._v("Output Series:")]),s._v(" Output a single series. The type is the same as the input. It is the input without anomalies.")]),s._v(" "),a("p",[a("strong",[s._v("Parameter:")])]),s._v(" "),a("ul",[a("li",[a("p",[a("code",[s._v("len")]),s._v(": The size of the window, which is a positive integer. By default, it's 5. When "),a("code",[s._v("len")]),s._v("=3, the algorithm detects forward window and backward window with length 3 and calculates the outlierness of the current point.")])]),s._v(" "),a("li",[a("p",[a("code",[s._v("threshold")]),s._v(": The threshold of outlierness, which is a floating number in (0,1). By default, it's 0.3. The strict standard of detecting anomalies is in proportion to the threshold.")])])]),s._v(" "),a("h3",{attrs:{id:"examples-6"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#examples-6"}},[s._v("#")]),s._v(" Examples")]),s._v(" "),a("p",[s._v("Input series:")]),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 for query:")]),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("Output series:")]),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=t.exports}}]); |