| (window.webpackJsonp=window.webpackJsonp||[]).push([[553],{948:function(s,t,a){"use strict";a.r(t);var e=a(29),n=Object(e.a)({},(function(){var s=this,t=s._self._c;return t("ContentSlotsDistributor",{attrs:{"slot-key":s.$parent.slotKey}},[t("h1",{attrs:{id:"序列处理"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#序列处理"}},[s._v("#")]),s._v(" 序列处理")]),s._v(" "),t("h2",{attrs:{id:"dedup"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#dedup"}},[s._v("#")]),s._v(" DEDUP")]),s._v(" "),t("h3",{attrs:{id:"函数简介"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#函数简介"}},[s._v("#")]),s._v(" 函数简介")]),s._v(" "),t("p",[s._v("本函数用于去除输入序列中的连续相同值。如输入序列"),t("code",[s._v("1，1，2，2，3")]),s._v("输出序列为"),t("code",[s._v("1，2，3")]),s._v("。")]),s._v(" "),t("p",[t("strong",[s._v("函数名：")]),s._v(" DEDUP")]),s._v(" "),t("p",[t("strong",[s._v("输入序列：")]),s._v(" 仅支持输入1个序列。")]),s._v(" "),t("p",[t("strong",[s._v("参数：")]),s._v(" 无")]),s._v(" "),t("h3",{attrs:{id:"使用示例"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#使用示例"}},[s._v("#")]),s._v(" 使用示例")]),s._v(" "),t("p",[s._v("原始数据：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("+-----------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+--------------------+\n| Time|root.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语句：")]),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("输出序列：")]),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}}]); |