| (window.webpackJsonp=window.webpackJsonp||[]).push([[122],{516:function(s,t,e){"use strict";e.r(t);var a=e(29),n=Object(a.a)({},(function(){var s=this,t=s._self._c;return t("ContentSlotsDistributor",{attrs:{"slot-key":s.$parent.slotKey}},[t("h1",{attrs:{id:"series-processing"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#series-processing"}},[s._v("#")]),s._v(" Series Processing")]),s._v(" "),t("h2",{attrs:{id:"dedup"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#dedup"}},[s._v("#")]),s._v(" DEDUP")]),s._v(" "),t("h3",{attrs:{id:"usage"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#usage"}},[s._v("#")]),s._v(" Usage")]),s._v(" "),t("p",[s._v("This function is used to remove consecutive identical values from an input sequence.\nFor example, input:"),t("code",[s._v("1，1，2，2，3")]),s._v(" output:"),t("code",[s._v("1，2，3")]),s._v(".")]),s._v(" "),t("p",[t("strong",[s._v("Name：")]),s._v(" DEDUP")]),s._v(" "),t("p",[t("strong",[s._v("Input Series：")]),s._v(" Support only one input series.")]),s._v(" "),t("p",[t("strong",[s._v("Parameters：")]),s._v(" No parameters.")]),s._v(" "),t("h3",{attrs:{id:"example"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#example"}},[s._v("#")]),s._v(" Example")]),s._v(" "),t("p",[s._v("Raw data：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+--------------------+\n| Time|root.testDeDup.d1.s1|root.testDeDup.d1.s2|root.testDeDup.d1.s3|root.testDeDup.d1.s4|root.testDeDup.d1.s5|root.testDeDup.d1.s6|\n+-----------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+--------------------+\n|1970-01-01T08:00:00.001+08:00| true| 1| 1| 1.0| 1.0| 1test1|\n|1970-01-01T08:00:00.002+08:00| true| 2| 2| 2.0| 1.0| 2test2|\n|1970-01-01T08:00:00.003+08:00| false| 1| 2| 1.0| 1.0| 2test2|\n|1970-01-01T08:00:00.004+08:00| true| 1| 3| 1.0| 1.0| 1test1|\n|1970-01-01T08:00:00.005+08:00| true| 1| 3| 1.0| 1.0| 1test1|\n+-----------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+--------------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br"),t("span",{staticClass:"line-number"},[s._v("9")]),t("br")])]),t("p",[s._v("SQL for query：")]),s._v(" "),t("div",{staticClass:"language-sql line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-sql"}},[t("code",[t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("select")]),s._v(" deDup"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s1"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" deDup"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s2"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" deDup"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s3"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" deDup"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s4"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" deDup"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s5"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(",")]),s._v(" deDup"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v("(")]),s._v("s6"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(")")]),s._v(" "),t("span",{pre:!0,attrs:{class:"token keyword"}},[s._v("from")]),s._v(" root"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("testDeDup"),t("span",{pre:!0,attrs:{class:"token punctuation"}},[s._v(".")]),s._v("d1\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("Output series：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+\n| Time|deDup(root.testDeDup.d1.s1)|deDup(root.testDeDup.d1.s2)|deDup(root.testDeDup.d1.s3)|deDup(root.testDeDup.d1.s4)|deDup(root.testDeDup.d1.s5)|deDup(root.testDeDup.d1.s6)|\n+-----------------------------+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+\n|1970-01-01T08:00:00.001+08:00| true| 1| 1| 1.0| 1.0| 1test1|\n|1970-01-01T08:00:00.002+08:00| null| 2| 2| 2.0| null| 2test2|\n|1970-01-01T08:00:00.003+08:00| false| 1| null| 1.0| null| null|\n|1970-01-01T08:00:00.004+08:00| true| null| 3| null| null| 1test1|\n+-----------------------------+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br"),t("span",{staticClass:"line-number"},[s._v("4")]),t("br"),t("span",{staticClass:"line-number"},[s._v("5")]),t("br"),t("span",{staticClass:"line-number"},[s._v("6")]),t("br"),t("span",{staticClass:"line-number"},[s._v("7")]),t("br"),t("span",{staticClass:"line-number"},[s._v("8")]),t("br")])])])}),[],!1,null,null,null);t.default=n.exports}}]); |