| "use strict";(self.webpackChunkdoris_website=self.webpackChunkdoris_website||[]).push([[77978],{15680:(r,e,a)=>{a.d(e,{xA:()=>c,yg:()=>m});var n=a(296540);function t(r,e,a){return e in r?Object.defineProperty(r,e,{value:a,enumerable:!0,configurable:!0,writable:!0}):r[e]=a,r}function l(r,e){var a=Object.keys(r);if(Object.getOwnPropertySymbols){var n=Object.getOwnPropertySymbols(r);e&&(n=n.filter((function(e){return Object.getOwnPropertyDescriptor(r,e).enumerable}))),a.push.apply(a,n)}return a}function i(r){for(var e=1;e<arguments.length;e++){var a=null!=arguments[e]?arguments[e]:{};e%2?l(Object(a),!0).forEach((function(e){t(r,e,a[e])})):Object.getOwnPropertyDescriptors?Object.defineProperties(r,Object.getOwnPropertyDescriptors(a)):l(Object(a)).forEach((function(e){Object.defineProperty(r,e,Object.getOwnPropertyDescriptor(a,e))}))}return r}function s(r,e){if(null==r)return{};var a,n,t=function(r,e){if(null==r)return{};var a,n,t={},l=Object.keys(r);for(n=0;n<l.length;n++)a=l[n],e.indexOf(a)>=0||(t[a]=r[a]);return t}(r,e);if(Object.getOwnPropertySymbols){var l=Object.getOwnPropertySymbols(r);for(n=0;n<l.length;n++)a=l[n],e.indexOf(a)>=0||Object.prototype.propertyIsEnumerable.call(r,a)&&(t[a]=r[a])}return t}var o=n.createContext({}),y=function(r){var e=n.useContext(o),a=e;return r&&(a="function"==typeof r?r(e):i(i({},e),r)),a},c=function(r){var e=y(r.components);return n.createElement(o.Provider,{value:e},r.children)},u="mdxType",f={inlineCode:"code",wrapper:function(r){var e=r.children;return n.createElement(n.Fragment,{},e)}},p=n.forwardRef((function(r,e){var a=r.components,t=r.mdxType,l=r.originalType,o=r.parentName,c=s(r,["components","mdxType","originalType","parentName"]),u=y(a),p=t,m=u["".concat(o,".").concat(p)]||u[p]||f[p]||l;return a?n.createElement(m,i(i({ref:e},c),{},{components:a})):n.createElement(m,i({ref:e},c))}));function m(r,e){var a=arguments,t=e&&e.mdxType;if("string"==typeof r||t){var l=a.length,i=new Array(l);i[0]=p;var s={};for(var o in e)hasOwnProperty.call(e,o)&&(s[o]=e[o]);s.originalType=r,s[u]="string"==typeof r?r:t,i[1]=s;for(var y=2;y<l;y++)i[y]=a[y];return n.createElement.apply(null,i)}return n.createElement.apply(null,a)}p.displayName="MDXCreateElement"},167288:(r,e,a)=>{a.r(e),a.d(e,{assets:()=>o,contentTitle:()=>i,default:()=>f,frontMatter:()=>l,metadata:()=>s,toc:()=>y});var n=a(58168),t=(a(296540),a(15680));const l={title:"array_filter",language:"en"},i=void 0,s={unversionedId:"sql-manual/sql-functions/array-functions/array_filter",id:"version-1.2/sql-manual/sql-functions/array-functions/array_filter",title:"array_filter",description:"\x3c!--",source:"@site/versioned_docs/version-1.2/sql-manual/sql-functions/array-functions/array_filter.md",sourceDirName:"sql-manual/sql-functions/array-functions",slug:"/sql-manual/sql-functions/array-functions/array_filter",permalink:"/docs/1.2/sql-manual/sql-functions/array-functions/array_filter",draft:!1,tags:[],version:"1.2",frontMatter:{title:"array_filter",language:"en"},sidebar:"docs",previous:{title:"array_map",permalink:"/docs/1.2/sql-manual/sql-functions/array-functions/array_map"},next:{title:"array_avg",permalink:"/docs/1.2/sql-manual/sql-functions/array-functions/array_avg"}},o={},y=[{value:"array_filter",id:"array_filter",level:2},{value:"description",id:"description",level:3},{value:"Syntax",id:"syntax",level:4},{value:"example",id:"example",level:3},{value:"keywords",id:"keywords",level:3}],c={toc:y},u="wrapper";function f(r){let{components:e,...a}=r;return(0,t.yg)(u,(0,n.A)({},c,a,{components:e,mdxType:"MDXLayout"}),(0,t.yg)("h2",{id:"array_filter"},"array_filter"),(0,t.yg)("version",{since:"2.0"},(0,t.yg)("p",null,"array_filter(lambda,array)")),(0,t.yg)("h3",{id:"description"},"description"),(0,t.yg)("h4",{id:"syntax"},"Syntax"),(0,t.yg)("pre",null,(0,t.yg)("code",{parentName:"pre",className:"language-sql"},"ARRAY<T> array_filter(lambda, ARRAY<T> arr1, ARRAY<T> arr2, ... )\nARRAY<T> array_filter(ARRAY<T> arr)\n")),(0,t.yg)("p",null,"Use the lambda expression as the input parameter to calculate and filter the data of the ARRAY column of the other input parameter.\nAnd filter out the values of 0 and NULL in the result."),(0,t.yg)("pre",null,(0,t.yg)("code",{parentName:"pre"},"array_filter(x->x>0, array1);\narray_filter(x->(x+2)=10, array1);\narray_filter(x->(abs(x)-2)>0, array1);\n")),(0,t.yg)("h3",{id:"example"},"example"),(0,t.yg)("pre",null,(0,t.yg)("code",{parentName:"pre",className:"language-shell"},"\nmysql [test]>select array_filter(x->(x > 1),[1,2,3,0,null]);\n+----------------------------------------------------------------------------------------------+\n| array_filter(ARRAY(1, 2, 3, 0, NULL), array_map([x] -> (x(0) > 1), ARRAY(1, 2, 3, 0, NULL))) |\n+----------------------------------------------------------------------------------------------+\n| [2, 3] |\n+----------------------------------------------------------------------------------------------+\n\nmysql [test]>select *, array_filter(x->x>0,c_array2) from array_test2;\n+------+-----------------+-------------------------+------------------------------------------------------------------+\n| id | c_array1 | c_array2 | array_filter(`c_array2`, array_map([x] -> x(0) > 0, `c_array2`)) |\n+------+-----------------+-------------------------+------------------------------------------------------------------+\n| 1 | [1, 2, 3, 4, 5] | [10, 20, -40, 80, -100] | [10, 20, 80] |\n| 2 | [6, 7, 8] | [10, 12, 13] | [10, 12, 13] |\n| 3 | [1] | [-100] | [] |\n| 4 | NULL | NULL | NULL |\n+------+-----------------+-------------------------+------------------------------------------------------------------+\n4 rows in set (0.01 sec)\n\nmysql [test]>select *, array_filter(x->x%2=0,c_array2) from array_test2;\n+------+-----------------+-------------------------+----------------------------------------------------------------------+\n| id | c_array1 | c_array2 | array_filter(`c_array2`, array_map([x] -> x(0) % 2 = 0, `c_array2`)) |\n+------+-----------------+-------------------------+----------------------------------------------------------------------+\n| 1 | [1, 2, 3, 4, 5] | [10, 20, -40, 80, -100] | [10, 20, -40, 80, -100] |\n| 2 | [6, 7, 8] | [10, 12, 13] | [10, 12] |\n| 3 | [1] | [-100] | [-100] |\n| 4 | NULL | NULL | NULL |\n+------+-----------------+-------------------------+----------------------------------------------------------------------+\n\nmysql [test]>select *, array_filter(x->(x*(-10)>0),c_array2) from array_test2;\n+------+-----------------+-------------------------+----------------------------------------------------------------------------+\n| id | c_array1 | c_array2 | array_filter(`c_array2`, array_map([x] -> (x(0) * (-10) > 0), `c_array2`)) |\n+------+-----------------+-------------------------+----------------------------------------------------------------------------+\n| 1 | [1, 2, 3, 4, 5] | [10, 20, -40, 80, -100] | [-40, -100] |\n| 2 | [6, 7, 8] | [10, 12, 13] | [] |\n| 3 | [1] | [-100] | [-100] |\n| 4 | NULL | NULL | NULL |\n+------+-----------------+-------------------------+----------------------------------------------------------------------------+\n\nmysql [test]>select *, array_filter(x->x>0, array_map((x,y)->(x>y), c_array1,c_array2)) as res from array_test2;\n+------+-----------------+-------------------------+--------+\n| id | c_array1 | c_array2 | res |\n+------+-----------------+-------------------------+--------+\n| 1 | [1, 2, 3, 4, 5] | [10, 20, -40, 80, -100] | [1, 1] |\n| 2 | [6, 7, 8] | [10, 12, 13] | [] |\n| 3 | [1] | [-100] | [1] |\n| 4 | NULL | NULL | NULL |\n+------+-----------------+-------------------------+--------+\n")),(0,t.yg)("h3",{id:"keywords"},"keywords"),(0,t.yg)("p",null,"ARRAY,FILTER,ARRAY_FILTER"))}f.isMDXComponent=!0}}]); |