| (window.webpackJsonp=window.webpackJsonp||[]).push([[548],{944: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:"conv"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#conv"}},[s._v("#")]),s._v(" Conv")]),s._v(" "),a("h3",{attrs:{id:"函数简介"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#函数简介"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),a("p",[s._v("本函数对两个输入序列进行卷积，即多项式乘法。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" CONV")]),s._v(" "),a("p",[a("strong",[s._v("输入序列：")]),s._v(" 仅支持两个输入序列，类型均为 INT32 / INT64 / FLOAT / DOUBLE")]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为DOUBLE，它是两个序列卷积的结果。序列的时间戳从0开始，仅用于表示顺序。")]),s._v(" "),a("p",[a("strong",[s._v("提示：")]),s._v(" 输入序列中的"),a("code",[s._v("NaN")]),s._v("将被忽略。")]),s._v(" "),a("h3",{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.d2.s1|root.test.d2.s2|\n+-----------------------------+---------------+---------------+\n|1970-01-01T08:00:00.000+08:00| 1.0| 7.0|\n|1970-01-01T08:00:00.001+08:00| 0.0| 2.0|\n|1970-01-01T08:00:00.002+08:00| 1.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("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(" conv"),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("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|conv(root.test.d2.s1, root.test.d2.s2)|\n+-----------------------------+--------------------------------------+\n|1970-01-01T08:00:00.000+08:00| 7.0|\n|1970-01-01T08:00:00.001+08:00| 2.0|\n|1970-01-01T08:00:00.002+08:00| 7.0|\n|1970-01-01T08:00:00.003+08:00| 2.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:"deconv"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#deconv"}},[s._v("#")]),s._v(" Deconv")]),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("本函数对两个输入序列进行去卷积，即多项式除法运算。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" DECONV")]),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("result")]),s._v("：去卷积的结果，取值为'quotient'或'remainder'，分别对应于去卷积的商和余数。在缺省情况下，输出去卷积的商。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为DOUBLE。它是将第二个序列从第一个序列中去卷积（第一个序列除以第二个序列）的结果。序列的时间戳从0开始，仅用于表示顺序。")]),s._v(" "),a("p",[a("strong",[s._v("提示：")]),s._v(" 输入序列中的"),a("code",[s._v("NaN")]),s._v("将被忽略。")]),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:"计算去卷积的商"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#计算去卷积的商"}},[s._v("#")]),s._v(" 计算去卷积的商")]),s._v(" "),a("p",[s._v("当"),a("code",[s._v("result")]),s._v("参数缺省或为'quotient'时，本函数计算去卷积的商。")]),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.s3|root.test.d2.s2|\n+-----------------------------+---------------+---------------+\n|1970-01-01T08:00:00.000+08:00| 8.0| 7.0|\n|1970-01-01T08:00:00.001+08:00| 2.0| 2.0|\n|1970-01-01T08:00:00.002+08:00| 7.0| null|\n|1970-01-01T08:00:00.003+08:00| 2.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("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(" deconv"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s3"),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("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|deconv(root.test.d2.s3, root.test.d2.s2)|\n+-----------------------------+----------------------------------------+\n|1970-01-01T08:00:00.000+08:00| 1.0|\n|1970-01-01T08:00:00.001+08:00| 0.0|\n|1970-01-01T08:00:00.002+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("h4",{attrs:{id:"计算去卷积的余数"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#计算去卷积的余数"}},[s._v("#")]),s._v(" 计算去卷积的余数")]),s._v(" "),a("p",[s._v("当"),a("code",[s._v("result")]),s._v("参数为'remainder'时，本函数计算去卷积的余数。输入序列同上，用于查询的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(" deconv"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s3"),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("'result'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'remainder'")]),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|deconv(root.test.d2.s3, root.test.d2.s2, "result"="remainder")|\n+-----------------------------+--------------------------------------------------------------+\n|1970-01-01T08:00:00.000+08:00| 1.0|\n|1970-01-01T08:00:00.001+08:00| 0.0|\n|1970-01-01T08:00:00.002+08:00| 0.0|\n|1970-01-01T08:00:00.003+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:"dwt"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#dwt"}},[s._v("#")]),s._v(" DWT")]),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("本函数对输入序列进行一维离散小波变换。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" DWT")]),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("：小波滤波的类型，提供'Haar', 'DB4', 'DB6', 'DB8'，其中DB指代Daubechies。若不设置该参数，则用户需提供小波滤波的系数。不区分大小写。")]),s._v(" "),a("li",[a("code",[s._v("coef")]),s._v("：小波滤波的系数。若提供该参数，请使用英文逗号','分割各项，不添加空格或其它符号。")]),s._v(" "),a("li",[a("code",[s._v("layer")]),s._v("：进行变换的次数，最终输出的向量个数等同于$layer+1$.默认取1。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为DOUBLE，长度与输入相等。")]),s._v(" "),a("p",[a("strong",[s._v("提示：")]),s._v(" 输入序列长度必须为2的整数次幂。")]),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:"haar变换"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#haar变换"}},[s._v("#")]),s._v(" Haar变换")]),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.000+08:00| 0.0|\n|1970-01-01T08:00:00.100+08:00| 0.2|\n|1970-01-01T08:00:00.200+08:00| 1.5|\n|1970-01-01T08:00:00.300+08:00| 1.2|\n|1970-01-01T08:00:00.400+08:00| 0.6|\n|1970-01-01T08:00:00.500+08:00| 1.7|\n|1970-01-01T08:00:00.600+08:00| 0.8|\n|1970-01-01T08:00:00.700+08:00| 2.0|\n|1970-01-01T08:00:00.800+08:00| 2.5|\n|1970-01-01T08:00:00.900+08:00| 2.1|\n|1970-01-01T08:00:01.000+08:00| 0.0|\n|1970-01-01T08:00:01.100+08:00| 2.0|\n|1970-01-01T08:00:01.200+08:00| 1.8|\n|1970-01-01T08:00:01.300+08:00| 1.2|\n|1970-01-01T08:00:01.400+08:00| 1.0|\n|1970-01-01T08:00:01.500+08:00| 1.6|\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("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(" dwt"),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('"method"')]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v('"haar"')]),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\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|dwt(root.test.d1.s1, "method"="haar")|\n+-----------------------------+-------------------------------------+\n|1970-01-01T08:00:00.000+08:00| 0.14142135834465192|\n|1970-01-01T08:00:00.100+08:00| 1.909188342921157|\n|1970-01-01T08:00:00.200+08:00| 1.6263456473052773|\n|1970-01-01T08:00:00.300+08:00| 1.9798989957517026|\n|1970-01-01T08:00:00.400+08:00| 3.252691126023161|\n|1970-01-01T08:00:00.500+08:00| 1.414213562373095|\n|1970-01-01T08:00:00.600+08:00| 2.1213203435596424|\n|1970-01-01T08:00:00.700+08:00| 1.8384776479437628|\n|1970-01-01T08:00:00.800+08:00| -0.14142135834465192|\n|1970-01-01T08:00:00.900+08:00| 0.21213200063848547|\n|1970-01-01T08:00:01.000+08:00| -0.7778174761639416|\n|1970-01-01T08:00:01.100+08:00| -0.8485281289944873|\n|1970-01-01T08:00:01.200+08:00| 0.2828427799095765|\n|1970-01-01T08:00:01.300+08:00| -1.414213562373095|\n|1970-01-01T08:00:01.400+08:00| 0.42426400127697095|\n|1970-01-01T08:00:01.500+08:00| -0.42426408557066786|\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:"fft"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#fft"}},[s._v("#")]),s._v(" FFT")]),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(" FFT")]),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("：傅里叶变换的类型，取值为'uniform'或'nonuniform'，缺省情况下为'uniform'。当取值为'uniform'时，时间戳将被忽略，所有数据点都将被视作等距的，并应用等距快速傅里叶算法；当取值为'nonuniform'时，将根据时间戳应用非等距快速傅里叶算法（未实现）。")]),s._v(" "),a("li",[a("code",[s._v("result")]),s._v("：傅里叶变换的结果，取值为'real'、'imag'、'abs'或'angle'，分别对应于变换结果的实部、虚部、模和幅角。在缺省情况下，输出变换的模。")]),s._v(" "),a("li",[a("code",[s._v("compress")]),s._v("：压缩参数，取值范围(0,1]，是有损压缩时保留的能量比例。在缺省情况下，不进行压缩。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为DOUBLE，长度与输入相等。序列的时间戳从0开始，仅用于表示顺序。")]),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("h4",{attrs:{id:"等距傅里叶变换"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#等距傅里叶变换"}},[s._v("#")]),s._v(" 等距傅里叶变换")]),s._v(" "),a("p",[s._v("当"),a("code",[s._v("type")]),s._v("参数缺省或为'uniform'时，本函数进行等距傅里叶变换。")]),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.000+08:00| 2.902113|\n|1970-01-01T08:00:01.000+08:00| 1.1755705|\n|1970-01-01T08:00:02.000+08:00| -2.1755705|\n|1970-01-01T08:00:03.000+08:00| -1.9021131|\n|1970-01-01T08:00:04.000+08:00| 1.0|\n|1970-01-01T08:00:05.000+08:00| 1.9021131|\n|1970-01-01T08:00:06.000+08:00| 0.1755705|\n|1970-01-01T08:00:07.000+08:00| -1.1755705|\n|1970-01-01T08:00:08.000+08:00| -0.902113|\n|1970-01-01T08:00:09.000+08:00| 0.0|\n|1970-01-01T08:00:10.000+08:00| 0.902113|\n|1970-01-01T08:00:11.000+08:00| 1.1755705|\n|1970-01-01T08:00:12.000+08:00| -0.1755705|\n|1970-01-01T08:00:13.000+08:00| -1.9021131|\n|1970-01-01T08:00:14.000+08:00| -1.0|\n|1970-01-01T08:00:15.000+08:00| 1.9021131|\n|1970-01-01T08:00:16.000+08:00| 2.1755705|\n|1970-01-01T08:00:17.000+08:00| -1.1755705|\n|1970-01-01T08:00:18.000+08:00| -2.902113|\n|1970-01-01T08:00:19.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(" fft"),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"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\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| fft(root.test.d1.s1)|\n+-----------------------------+----------------------+\n|1970-01-01T08:00:00.000+08:00| 0.0|\n|1970-01-01T08:00:00.001+08:00| 1.2727111142703152E-8|\n|1970-01-01T08:00:00.002+08:00| 2.385520799101839E-7|\n|1970-01-01T08:00:00.003+08:00| 8.723291723972645E-8|\n|1970-01-01T08:00:00.004+08:00| 19.999999960195904|\n|1970-01-01T08:00:00.005+08:00| 9.999999850988388|\n|1970-01-01T08:00:00.006+08:00| 3.2260694930700566E-7|\n|1970-01-01T08:00:00.007+08:00| 8.723291605373329E-8|\n|1970-01-01T08:00:00.008+08:00| 1.108657103979944E-7|\n|1970-01-01T08:00:00.009+08:00| 1.2727110997246171E-8|\n|1970-01-01T08:00:00.010+08:00|1.9852334701272664E-23|\n|1970-01-01T08:00:00.011+08:00| 1.2727111194499847E-8|\n|1970-01-01T08:00:00.012+08:00| 1.108657103979944E-7|\n|1970-01-01T08:00:00.013+08:00| 8.723291785769131E-8|\n|1970-01-01T08:00:00.014+08:00| 3.226069493070057E-7|\n|1970-01-01T08:00:00.015+08:00| 9.999999850988388|\n|1970-01-01T08:00:00.016+08:00| 19.999999960195904|\n|1970-01-01T08:00:00.017+08:00| 8.723291747109068E-8|\n|1970-01-01T08:00:00.018+08:00| 2.3855207991018386E-7|\n|1970-01-01T08:00:00.019+08:00| 1.2727112069910878E-8|\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("注：输入序列服从$y=sin(2\\pi t/4)+2sin(2\\pi t/5)$，长度为20，因此在输出序列中$k=4$和$k=5$处有尖峰。")]),s._v(" "),a("h4",{attrs:{id:"等距傅里叶变换并压缩"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#等距傅里叶变换并压缩"}},[s._v("#")]),s._v(" 等距傅里叶变换并压缩")]),s._v(" "),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(" fft"),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("'result'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'real'")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'compress'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'0.99'")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" fft"),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("'result'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'imag'")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'compress'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'0.99'")]),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\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| fft(root.test.d1.s1,| fft(root.test.d1.s1,|\n| | "result"="real",| "result"="imag",|\n| | "compress"="0.99")| "compress"="0.99")|\n+-----------------------------+----------------------+----------------------+\n|1970-01-01T08:00:00.000+08:00| 0.0| 0.0|\n|1970-01-01T08:00:00.001+08:00| -3.932894010461041E-9| 1.2104201863039066E-8|\n|1970-01-01T08:00:00.002+08:00|-1.4021739447490164E-7| 1.9299268669082926E-7|\n|1970-01-01T08:00:00.003+08:00| -7.057291240286645E-8| 5.127422242345858E-8|\n|1970-01-01T08:00:00.004+08:00| 19.021130288047125| -6.180339875198807|\n|1970-01-01T08:00:00.005+08:00| 9.999999850988388| 3.501852745067114E-16|\n|1970-01-01T08:00:00.019+08:00| -3.932894898639461E-9|-1.2104202549376264E-8|\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("注：基于傅里叶变换结果的共轭性质，压缩结果只保留前一半；根据给定的压缩参数，从低频到高频保留数据点，直到保留的能量比例超过该值；保留最后一个数据点以表示序列长度。")]),s._v(" "),a("h2",{attrs:{id:"highpass"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#highpass"}},[s._v("#")]),s._v(" HighPass")]),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(" HIGHPASS")]),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("wpass")]),s._v("：归一化后的截止频率，取值为(0,1)，不可缺省。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为DOUBLE，它是滤波后的序列，长度与时间戳均与输入一致。")]),s._v(" "),a("p",[a("strong",[s._v("提示：")]),s._v(" 输入序列中的"),a("code",[s._v("NaN")]),s._v("将被忽略。")]),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("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.000+08:00| 2.902113|\n|1970-01-01T08:00:01.000+08:00| 1.1755705|\n|1970-01-01T08:00:02.000+08:00| -2.1755705|\n|1970-01-01T08:00:03.000+08:00| -1.9021131|\n|1970-01-01T08:00:04.000+08:00| 1.0|\n|1970-01-01T08:00:05.000+08:00| 1.9021131|\n|1970-01-01T08:00:06.000+08:00| 0.1755705|\n|1970-01-01T08:00:07.000+08:00| -1.1755705|\n|1970-01-01T08:00:08.000+08:00| -0.902113|\n|1970-01-01T08:00:09.000+08:00| 0.0|\n|1970-01-01T08:00:10.000+08:00| 0.902113|\n|1970-01-01T08:00:11.000+08:00| 1.1755705|\n|1970-01-01T08:00:12.000+08:00| -0.1755705|\n|1970-01-01T08:00:13.000+08:00| -1.9021131|\n|1970-01-01T08:00:14.000+08:00| -1.0|\n|1970-01-01T08:00:15.000+08:00| 1.9021131|\n|1970-01-01T08:00:16.000+08:00| 2.1755705|\n|1970-01-01T08:00:17.000+08:00| -1.1755705|\n|1970-01-01T08:00:18.000+08:00| -2.902113|\n|1970-01-01T08:00:19.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(" highpass"),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("'wpass'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'0.45'")]),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\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|highpass(root.test.d1.s1, "wpass"="0.45")|\n+-----------------------------+-----------------------------------------+\n|1970-01-01T08:00:00.000+08:00| 0.9999999534830373|\n|1970-01-01T08:00:01.000+08:00| 1.7462829277628608E-8|\n|1970-01-01T08:00:02.000+08:00| -0.9999999593178128|\n|1970-01-01T08:00:03.000+08:00| -4.1115269056426626E-8|\n|1970-01-01T08:00:04.000+08:00| 0.9999999925494194|\n|1970-01-01T08:00:05.000+08:00| 3.328126513330016E-8|\n|1970-01-01T08:00:06.000+08:00| -1.0000000183304454|\n|1970-01-01T08:00:07.000+08:00| 6.260191433311374E-10|\n|1970-01-01T08:00:08.000+08:00| 1.0000000018134796|\n|1970-01-01T08:00:09.000+08:00| -3.097210911744423E-17|\n|1970-01-01T08:00:10.000+08:00| -1.0000000018134794|\n|1970-01-01T08:00:11.000+08:00| -6.260191627862097E-10|\n|1970-01-01T08:00:12.000+08:00| 1.0000000183304454|\n|1970-01-01T08:00:13.000+08:00| -3.328126501424346E-8|\n|1970-01-01T08:00:14.000+08:00| -0.9999999925494196|\n|1970-01-01T08:00:15.000+08:00| 4.111526915498874E-8|\n|1970-01-01T08:00:16.000+08:00| 0.9999999593178128|\n|1970-01-01T08:00:17.000+08:00| -1.7462829341296528E-8|\n|1970-01-01T08:00:18.000+08:00| -0.9999999534830369|\n|1970-01-01T08:00:19.000+08:00| -1.035237222742873E-16|\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("注：输入序列服从$y=sin(2\\pi t/4)+2sin(2\\pi t/5)$，长度为20，因此高通滤波之后的输出序列服从$y=sin(2\\pi t/4)$。")]),s._v(" "),a("h2",{attrs:{id:"ifft"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#ifft"}},[s._v("#")]),s._v(" IFFT")]),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("本函数将输入的两个序列作为实部和虚部视作一个复数，进行逆快速傅里叶变换，并输出结果的实部。输入数据的格式参见"),a("code",[s._v("FFT")]),s._v("函数的输出，并支持以"),a("code",[s._v("FFT")]),s._v("函数压缩后的输出作为本函数的输入。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" IFFT")]),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("start")]),s._v("：输出序列的起始时刻，是一个格式为'yyyy-MM-dd HH:mm:ss'的时间字符串。在缺省情况下，为'1970-01-01 08:00:00'。")]),s._v(" "),a("li",[a("code",[s._v("interval")]),s._v("：输出序列的时间间隔，是一个有单位的正数。目前支持五种单位，分别是'ms'（毫秒）、's'（秒）、'm'（分钟）、'h'（小时）和'd'（天）。在缺省情况下，为1s。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为DOUBLE。该序列是一个等距时间序列，它的值是将两个输入序列依次作为实部和虚部进行逆快速傅里叶变换的结果。")]),s._v(" "),a("p",[a("strong",[s._v("提示：")]),s._v(" 如果某行数据中包含空值或"),a("code",[s._v("NaN")]),s._v("，该行数据将会被忽略。")]),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.d1.re| root.test.d1.im|\n+-----------------------------+----------------------+----------------------+\n|1970-01-01T08:00:00.000+08:00| 0.0| 0.0|\n|1970-01-01T08:00:00.001+08:00| -3.932894010461041E-9| 1.2104201863039066E-8|\n|1970-01-01T08:00:00.002+08:00|-1.4021739447490164E-7| 1.9299268669082926E-7|\n|1970-01-01T08:00:00.003+08:00| -7.057291240286645E-8| 5.127422242345858E-8|\n|1970-01-01T08:00:00.004+08:00| 19.021130288047125| -6.180339875198807|\n|1970-01-01T08:00:00.005+08:00| 9.999999850988388| 3.501852745067114E-16|\n|1970-01-01T08:00:00.019+08:00| -3.932894898639461E-9|-1.2104202549376264E-8|\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("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(" ifft"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("re"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" im"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'interval'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'1m'")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" "),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'start'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'2021-01-01 00:00:00'")]),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\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|ifft(root.test.d1.re, root.test.d1.im, "interval"="1m",|\n| | "start"="2021-01-01 00:00:00")|\n+-----------------------------+-------------------------------------------------------+\n|2021-01-01T00:00:00.000+08:00| 2.902112992431231|\n|2021-01-01T00:01:00.000+08:00| 1.1755704705132448|\n|2021-01-01T00:02:00.000+08:00| -2.175570513757101|\n|2021-01-01T00:03:00.000+08:00| -1.9021130389094498|\n|2021-01-01T00:04:00.000+08:00| 0.9999999925494194|\n|2021-01-01T00:05:00.000+08:00| 1.902113046743454|\n|2021-01-01T00:06:00.000+08:00| 0.17557053610884188|\n|2021-01-01T00:07:00.000+08:00| -1.1755704886020932|\n|2021-01-01T00:08:00.000+08:00| -0.9021130371347148|\n|2021-01-01T00:09:00.000+08:00| 3.552713678800501E-16|\n|2021-01-01T00:10:00.000+08:00| 0.9021130371347154|\n|2021-01-01T00:11:00.000+08:00| 1.1755704886020932|\n|2021-01-01T00:12:00.000+08:00| -0.17557053610884144|\n|2021-01-01T00:13:00.000+08:00| -1.902113046743454|\n|2021-01-01T00:14:00.000+08:00| -0.9999999925494196|\n|2021-01-01T00:15:00.000+08:00| 1.9021130389094498|\n|2021-01-01T00:16:00.000+08:00| 2.1755705137571004|\n|2021-01-01T00:17:00.000+08:00| -1.1755704705132448|\n|2021-01-01T00:18:00.000+08:00| -2.902112992431231|\n|2021-01-01T00:19:00.000+08:00| -3.552713678800501E-16|\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:"lowpass"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#lowpass"}},[s._v("#")]),s._v(" LowPass")]),s._v(" "),a("h3",{attrs:{id:"函数简介-7"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#函数简介-7"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),a("p",[s._v("本函数对输入序列进行低通滤波，提取低于截止频率的分量。输入序列的时间戳将被忽略，所有数据点都将被视作等距的。")]),s._v(" "),a("p",[a("strong",[s._v("函数名：")]),s._v(" LOWPASS")]),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("wpass")]),s._v("：归一化后的截止频率，取值为(0,1)，不可缺省。")])]),s._v(" "),a("p",[a("strong",[s._v("输出序列：")]),s._v(" 输出单个序列，类型为DOUBLE，它是滤波后的序列，长度与时间戳均与输入一致。")]),s._v(" "),a("p",[a("strong",[s._v("提示：")]),s._v(" 输入序列中的"),a("code",[s._v("NaN")]),s._v("将被忽略。")]),s._v(" "),a("h3",{attrs:{id:"使用示例-7"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#使用示例-7"}},[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.000+08:00| 2.902113|\n|1970-01-01T08:00:01.000+08:00| 1.1755705|\n|1970-01-01T08:00:02.000+08:00| -2.1755705|\n|1970-01-01T08:00:03.000+08:00| -1.9021131|\n|1970-01-01T08:00:04.000+08:00| 1.0|\n|1970-01-01T08:00:05.000+08:00| 1.9021131|\n|1970-01-01T08:00:06.000+08:00| 0.1755705|\n|1970-01-01T08:00:07.000+08:00| -1.1755705|\n|1970-01-01T08:00:08.000+08:00| -0.902113|\n|1970-01-01T08:00:09.000+08:00| 0.0|\n|1970-01-01T08:00:10.000+08:00| 0.902113|\n|1970-01-01T08:00:11.000+08:00| 1.1755705|\n|1970-01-01T08:00:12.000+08:00| -0.1755705|\n|1970-01-01T08:00:13.000+08:00| -1.9021131|\n|1970-01-01T08:00:14.000+08:00| -1.0|\n|1970-01-01T08:00:15.000+08:00| 1.9021131|\n|1970-01-01T08:00:16.000+08:00| 2.1755705|\n|1970-01-01T08:00:17.000+08:00| -1.1755705|\n|1970-01-01T08:00:18.000+08:00| -2.902113|\n|1970-01-01T08:00:19.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(" lowpass"),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("'wpass'")]),a("span",{pre:!0,attrs:{class:"token operator"}},[s._v("=")]),a("span",{pre:!0,attrs:{class:"token string"}},[s._v("'0.45'")]),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\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|lowpass(root.test.d1.s1, "wpass"="0.45")|\n+-----------------------------+----------------------------------------+\n|1970-01-01T08:00:00.000+08:00| 1.9021130073323922|\n|1970-01-01T08:00:01.000+08:00| 1.1755704705132448|\n|1970-01-01T08:00:02.000+08:00| -1.1755705286582614|\n|1970-01-01T08:00:03.000+08:00| -1.9021130389094498|\n|1970-01-01T08:00:04.000+08:00| 7.450580419288145E-9|\n|1970-01-01T08:00:05.000+08:00| 1.902113046743454|\n|1970-01-01T08:00:06.000+08:00| 1.1755705212076808|\n|1970-01-01T08:00:07.000+08:00| -1.1755704886020932|\n|1970-01-01T08:00:08.000+08:00| -1.9021130222335536|\n|1970-01-01T08:00:09.000+08:00| 3.552713678800501E-16|\n|1970-01-01T08:00:10.000+08:00| 1.9021130222335536|\n|1970-01-01T08:00:11.000+08:00| 1.1755704886020932|\n|1970-01-01T08:00:12.000+08:00| -1.1755705212076801|\n|1970-01-01T08:00:13.000+08:00| -1.902113046743454|\n|1970-01-01T08:00:14.000+08:00| -7.45058112983088E-9|\n|1970-01-01T08:00:15.000+08:00| 1.9021130389094498|\n|1970-01-01T08:00:16.000+08:00| 1.1755705286582616|\n|1970-01-01T08:00:17.000+08:00| -1.1755704705132448|\n|1970-01-01T08:00:18.000+08:00| -1.9021130073323924|\n|1970-01-01T08:00:19.000+08:00| -2.664535259100376E-16|\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("注：输入序列服从$y=sin(2\\pi t/4)+2sin(2\\pi t/5)$，长度为20，因此低通滤波之后的输出序列服从$y=2sin(2\\pi t/5)$。")])])}),[],!1,null,null,null);a.default=e.exports}}]); |