1"use strict";(self.webpackChunkwebsite=self.webpackChunkwebsite||[]).push([[4692],{65888:(e,n,s)=>{s.r(n),s.d(n,{assets:()=>d,contentTitle:()=>l,default:()=>h,frontMatter:()=>i,metadata:()=>o,toc:()=>c});var t=s(74848),r=s(28453);const i={},l="IS_LIST",o={id:"sql/sql-functions/functions/IS_LIST",title:"IS_LIST",description:"Categories: Datatype, Variant Type",source:"@site/dremio-cloud/sql/sql-functions/functions/IS_LIST.md",sourceDirName:"sql/sql-functions/functions",slug:"/sql/sql-functions/functions/IS_LIST",permalink:"/dremio-cloud/sql/sql-functions/functions/IS_LIST",draft:!1,unlisted:!1,tags:[],version:"current",frontMatter:{},sidebar:"dremioCloudSidebar",previous:{title:"IS_INT",permalink:"/dremio-cloud/sql/sql-functions/functions/IS_INT"},next:{title:"IS_MEMBER",permalink:"/dremio-cloud/sql/sql-functions/functions/IS_MEMBER"}},d={},c=[{value:"Syntax",id:"syntax",level:2},{value:"IS_LIST(<em>value</em> VARIANT) \u2192 BOOLEAN",id:"is_listvalue-variant--boolean",level:3},{value:"Usage Notes",id:"usage-notes",level:2}];function a(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",table:"table",tbody:"tbody",td:"td",th:"th",thead:"thead",tr:"tr",ul:"ul",...(0,r.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,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/DATATYPE/",children:"Datatype"}),", ",(0,t.jsx)(n.a,{href:"/dremio-cloud/sql/sql%2Dfunctions/VARIANT_TYPE/",children:"Variant Type"})]}),"\n",(0,t.jsx)(n.header,{children:(0,t.jsx)(n.h1,{id:"is_list",children:"IS_LIST"})}),"\n",(0,t.jsx)(n.p,{children:"Returns TRUE if the input expression is a VARIANT<ARRAY>."}),"\n",(0,t.jsx)(n.h2,{id:"syntax",children:"Syntax"}),"\n",(0,t.jsxs)(n.h3,{id:"is_listvalue-variant--boolean",children:["IS_LIST(",(0,t.jsx)(n.em,{children:"value"})," VARIANT) \u2192 BOOLEAN"]}),"\n",(0,t.jsxs)(n.ul,{children:["\n",(0,t.jsx)(n.li,{children:"value: The VARIANT value to check."}),"\n"]}),"\n",(0,t.jsx)(n.p,{children:(0,t.jsx)(n.strong,{children:"Examples"})}),"\n",(0,t.jsx)(s,{children:"IS_LIST example"}),"\n",(0,t.jsx)(n.pre,{children:(0,t.jsx)(n.code,{className:"language-sql",children:"SELECT IS_LIST(PARSE_JSON('[1, 2, 3]'))\n-- TRUE\n"})}),"\n",(0,t.jsx)(s,{children:"IS_LIST example"}),"\n",(0,t.jsx)(n.pre,{children:(0,t.jsx)(n.code,{className:"language-sql",children:'SELECT IS_LIST(PARSE_JSON(\'{"name": "Alice"}\'))\n-- FALSE\n'})}),"\n",(0,t.jsx)(n.h2,{id:"usage-notes",children:"Usage Notes"}),"\n",(0,t.jsx)(n.p,{children:(0,t.jsx)(n.strong,{children:"NULL handling for VARIANT inputs"})}),"\n",(0,t.jsx)(n.p,{children:"If the input is SQL NULL (e.g., from a missing path), IS_LIST returns NULL."}),"\n",(0,t.jsxs)(n.table,{children:[(0,t.jsx)(n.thead,{children:(0,t.jsxs)(n.tr,{children:[(0,t.jsx)(n.th,{children:"Input"}),(0,t.jsx)(n.th,{children:"Result"})]})}),(0,t.jsxs)(n.tbody,{children:[(0,t.jsxs)(n.tr,{children:[(0,t.jsx)(n.td,{children:"VARIANT array"}),(0,t.jsx)(n.td,{children:"TRUE"})]}),(0,t.jsxs)(n.tr,{children:[(0,t.jsx)(n.td,{children:"VARIANT other type"}),(0,t.jsx)(n.td,{children:"FALSE"})]}),(0,t.jsxs)(n.tr,{children:[(0,t.jsx)(n.td,{children:"VARIANT null"}),(0,t.jsx)(n.td,{children:"FALSE"})]}),(0,t.jsxs)(n.tr,{children:[(0,t.jsx)(n.td,{children:"SQL NULL"}),(0,t.jsx)(n.td,{children:"NULL"})]})]})]})]})}function h(e={}){const{wrapper:n}={...(0,r.R)(),...e.components};return n?(0,t.jsx)(n,{...e,children:(0,t.jsx)(a,{...e})}):a(e)}},28453:(e,n,s)=>{s.d(n,{R:()=>l,x:()=>o});var t=s(96540);const r={},i=t.createContext(r);function l(e){const n=t.useContext(i);return t.useMemo((function(){return"function"==typeof e?e(n):{...n,...e}}),[n,e])}function o(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(r):e.components||r:l(e.components),t.createElement(i.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.