https://dremio-documentation.pages.dev/assets/js/0527ad43.bd20d044.js

1"use strict";(self.webpackChunkwebsite=self.webpackChunkwebsite||[]).push([[715],{40633:(e,n,s)=>{s.r(n),s.d(n,{assets:()=>o,contentTitle:()=>l,default:()=>d,frontMatter:()=>c,metadata:()=>i,toc:()=>a});var r=s(74848),t=s(28453);const c={},l="ARRAY_MIN",i={id:"reference/sql/sql-functions/functions/ARRAY_MIN",title:"ARRAY_MIN",description:"Categories: Aggregate, Semi-Structured Data",source:"@site/docs-cloud/reference/sql/sql-functions/functions/ARRAY_MIN.md",sourceDirName:"reference/sql/sql-functions/functions",slug:"/reference/sql/sql-functions/functions/ARRAY_MIN",permalink:"/cloud/reference/sql/sql-functions/functions/ARRAY_MIN",draft:!1,unlisted:!1,tags:[],version:"current",frontMatter:{},sidebar:"cloudSidebar",previous:{title:"ARRAY_MAX",permalink:"/cloud/reference/sql/sql-functions/functions/ARRAY_MAX"},next:{title:"ARRAY_POSITION",permalink:"/cloud/reference/sql/sql-functions/functions/ARRAY_POSITION"}},o={},a=[{value:"Syntax",id:"syntax",level:2},{value:"ARRAY_MIN(<em>list_column</em> LIST) \u2192 numeric",id:"array_minlist_column-list--numeric",level:3},{value:"Usage Notes",id:"usage-notes",level:2}];function u(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,t.R)(),...e.components},{CodeHeader:s}=n;return s||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,r.jsxs)(r.Fragment,{children:[(0,r.jsxs)(n.p,{children:[(0,r.jsx)(n.strong,{children:"Categories"}),": ",(0,r.jsx)(n.a,{href:"/cloud/reference/sql/sql%2Dfunctions/AGGREGATE",children:"Aggregate"}),", ",(0,r.jsx)(n.a,{href:"/cloud/reference/sql/sql%2Dfunctions/SEMI-STRUCTURED_DATA",children:"Semi-Structured Data"})]}),"\n",(0,r.jsx)(n.header,{children:(0,r.jsx)(n.h1,{id:"array_min",children:"ARRAY_MIN"})}),"\n",(0,r.jsx)(n.p,{children:"Returns the minimum value of a list."}),"\n",(0,r.jsx)(n.h2,{id:"syntax",children:"Syntax"}),"\n",(0,r.jsxs)(n.h3,{id:"array_minlist_column-list--numeric",children:["ARRAY_MIN(",(0,r.jsx)(n.em,{children:"list_column"})," LIST) \u2192 numeric"]}),"\n",(0,r.jsxs)(n.ul,{children:["\n",(0,r.jsx)(n.li,{children:"list_column: Column that contains a LIST expression. Every element of the list must be a number such as INT, BIGINT, FLOAT4, FLOAT8, or DECIMAL. Cannot be an array literal."}),"\n"]}),"\n",(0,r.jsx)(n.p,{children:(0,r.jsx)(n.strong,{children:"Examples"})}),"\n",(0,r.jsx)(s,{children:"array_col contains ARRAY[1, 2, 3]"}),"\n",(0,r.jsx)(n.pre,{children:(0,r.jsx)(n.code,{className:"language-sql",children:"SELECT ARRAY_MIN(array_col)\n-- 1\n"})}),"\n",(0,r.jsx)(s,{children:"array_col contains ARRAY[1,2,null]"}),"\n",(0,r.jsx)(n.pre,{children:(0,r.jsx)(n.code,{className:"language-sql",children:"SELECT ARRAY_MIN(array_col)\n-- NULL\n"})}),"\n",(0,r.jsx)(s,{children:"array_col contains ARRAY[null]"}),"\n",(0,r.jsx)(n.pre,{children:(0,r.jsx)(n.code,{className:"language-sql",children:"SELECT ARRAY_MIN(array_col)\n-- NULL\n"})}

1),"\n",(0,r.jsx)(s,{children:"array_col contains null"}),"\n",(0,r.jsx)(n.pre,{children:(0,r.jsx)(n.code,{className:"language-sql",children:"SELECT ARRAY_MIN(array_col)\n-- NULL\n"})}),"\n",(0,r.jsx)(n.h2,{id:"usage-notes",children:"Usage Notes"}),"\n",(0,r.jsxs)(n.p,{children:["The return type is T given an input ",(0,r.jsx)(n.code,{children:"ARRAY<T>"}),". If the parameter is NULL, this function returns NULL. If the list contains NULL, this function returns NULL. If the list is empty, this function returns NULL."]})]})}function d(e={}){const{wrapper:n}={...(0,t.R)(),...e.components};return n?(0,r.jsx)(n,{...e,children:(0,r.jsx)(u,{...e})}):u(e)}},28453:(e,n,s)=>{s.d(n,{R:()=>l,x:()=>i});var r=s(96540);const t={},c=r.createContext(t);function l(e){const n=r.useContext(c);return r.useMemo((function(){return"function"==typeof e?e(n):{...n,...e}}),[n,e])}function i(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(t):e.components||t:l(e.components),r.createElement(c.Provider,{value:n},e.children)}}}]);