1"use strict";(self.webpackChunkwebsite=self.webpackChunkwebsite||[]).push([[4500],{18771:(e,n,r)=>{r.r(n),r.d(n,{assets:()=>l,contentTitle:()=>i,default:()=>u,frontMatter:()=>o,metadata:()=>c,toc:()=>a});var t=r(74848),s=r(28453);const o={},i="ARRAY_CAT",c={id:"sql/sql-functions/functions/ARRAY_CAT",title:"ARRAY_CAT",description:"Categories: Semi-Structured Data",source:"@site/dremio-cloud/sql/sql-functions/functions/ARRAY_CAT.md",sourceDirName:"sql/sql-functions/functions",slug:"/sql/sql-functions/functions/ARRAY_CAT",permalink:"/dremio-cloud/sql/sql-functions/functions/ARRAY_CAT",draft:!1,unlisted:!1,tags:[],version:"current",frontMatter:{},sidebar:"dremioCloudSidebar",previous:{title:"ARRAY_AVG",permalink:"/dremio-cloud/sql/sql-functions/functions/ARRAY_AVG"},next:{title:"ARRAY_COMPACT",permalink:"/dremio-cloud/sql/sql-functions/functions/ARRAY_COMPACT"}},l={},a=[{value:"Syntax",id:"syntax",level:2},{value:"ARRAY_CAT(<em>arr1</em> LIST, <em>arr2</em> LIST) \u2192 list",id:"array_catarr1-list-arr2-list--list",level:3}];function d(e){const n={a:"a",code:"code",em:"em",h1:"h1",h2:"h2",h3:"h3",header:"header",li:"li",p:"p",pre:"pre",strong:"strong",ul:"ul",...(0,s.R)(),...e.components},{CodeHeader:r}=n;return r||function(e,n){throw new Error("Expected "+(n?"component":"object")+" `"+e+"` to be defined: you likely forgot to import, pass, or provide it.")}("CodeHeader",!0),(0,t.jsxs)(t.Fragment,{children:[(0,t.jsxs)(n.p,{children:[(0,t.jsx)(n.strong,{children:"Categories"}),": ",(0,t.jsx)(n.a,{href:"/dremio-cloud/sql/sql%2Dfunctions/SEMI-STRUCTURED_DATA/",children:"Semi-Structured Data"})]}),"\n",(0,t.jsx)(n.header,{children:(0,t.jsx)(n.h1,{id:"array_cat",children:"ARRAY_CAT"})}),"\n",(0,t.jsx)(n.p,{children:"Returns a concatenation of two arrays."}),"\n",(0,t.jsx)(n.h2,{id:"syntax",children:"Syntax"}),"\n",(0,t.jsxs)(n.h3,{id:"array_catarr1-list-arr2-list--list",children:["ARRAY_CAT(",(0,t.jsx)(n.em,{children:"arr1"})," LIST, ",(0,t.jsx)(n.em,{children:"arr2"})," LIST) \u2192 list"]}),"\n",(0,t.jsxs)(n.ul,{children:["\n",(0,t.jsx)(n.li,{children:"arr1: The source array."}),"\n",(0,t.jsx)(n.li,{children:"arr2: The array to be appended to the source array."}),"\n"]}),"\n",(0,t.jsx)(n.p,{children:(0,t.jsx)(n.strong,{children:"Examples"})}),"\n",(0,t.jsx)(r,{children:"ARRAY_CAT example"}),"\n",(0,t.jsx)(n.pre,{children:(0,t.jsx)(n.code,{className:"language-sql",children:"SELECT ARRAY_CAT(ARRAY[1, 2, 3], ARRAY[4, 5, 6])\n-- [1, 2, 3, 4, 5, 6]\n"})})]})}function u(e={}){const{wrapper:n}={...(0,s.R)(),...e.components};return n?(0,t.jsx)(n,{...e,children:(0,t.jsx)(d,{...e})}):d(e)}},28453:(e,n,r)=>{r.d(n,{R:()=>i,x:()=>c});var t=r(96540);const s={},o=t.createContext(s);function i(e){const n=t.useContext(o);return t.useMemo((function(){return"function"==typeof e?e(n):{...n,...e}}),[n,e])}function c(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(s):e.components||s:i(e.components),t.createElement(o.Provider,{value:n},e.children)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.