1"use strict";(self.webpackChunkstarrocks=self.webpackChunkstarrocks||[]).push([[4067],{28453:(e,t,n)=>{n.d(t,{R:()=>a,x:()=>o});var r=n(96540);let s={},i=r.createContext(s);function a(e){let t=r.useContext(i);return r.useMemo(function(){return"function"==typeof e?e(t):{...t,...e}},[t,e])}function o(e){let t;return t=e.disableParentContext?"function"==typeof e.components?e.components(s):e.components||s:a(e.components),r.createElement(i.Provider,{value:t},e.children)}},30039:(e,t,n)=>{n.r(t),n.d(t,{assets:()=>c,contentTitle:()=>o,default:()=>p,frontMatter:()=>a,metadata:()=>r,toc:()=>l});let r=JSON.parse('{"id":"sql-reference/sql-functions/bitmap-functions/bitmap_to_array","title":"bitmap_to_array","description":"\u5C06 BITMAP \u4E2D\u7684\u6240\u6709\u503C\u7EC4\u5408\u6210 BIGINT \u7C7B\u578B\u7684\u6570\u7EC4\u3002","source":"@site/i18n/zh/docusaurus-plugin-content-docs/version-3.5/sql-reference/sql-functions/bitmap-functions/bitmap_to_array.md","sourceDirName":"sql-reference/sql-functions/bitmap-functions","slug":"/sql-reference/sql-functions/bitmap-functions/bitmap_to_array","permalink":"/zh/docs/3.5/sql-reference/sql-functions/bitmap-functions/bitmap_to_array","draft":false,"unlisted":false,"editUrl":"https://github.com/StarRocks/starrocks/edit/main/docs/zh/sql-reference/sql-functions/bitmap-functions/bitmap_to_array.md","tags":[],"version":"3.5","frontMatter":{"displayed_sidebar":"docs"},"sidebar":"docs","previous":{"title":"bitmap_subset_limit","permalink":"/zh/docs/3.5/sql-reference/sql-functions/bitmap-functions/bitmap_subset_limit"},"next":{"title":"bitmap_to_base64","permalink":"/zh/docs/3.5/sql-reference/sql-functions/bitmap-functions/bitmap_to_base64"}}');var s=n(74848),i=n(28453);let a={displayed_sidebar:"docs"},o="bitmap_to_array",c={},l=[{value:"\u8BED\u6CD5",id:"\u8BED\u6CD5",level:2},{value:"\u53C2\u6570\u8BF4\u660E",id:"\u53C2\u6570\u8BF4\u660E",level:2},{value:"\u8FD4\u56DE\u503C\u8BF4\u660E",id:"\u8FD4\u56DE\u503C\u8BF4\u660E",level:2},{value:"\u793A\u4F8B",id:"\u793A\u4F8B",level:2}];function d(e){let t={code:"code",h1:"h1",h2:"h2",header:"header",p:"p",pre:"pre",...(0,i.R)(),...e.components};return(0,s.jsxs)(s.Fragment,{children:[(0,s.jsx)(t.header,{children:(0,s.jsx)(t.h1,{id:"bitmap_to_array",children:"bitmap_to_array"})}),"\n",(0,s.jsx)(t.p,{children:"\u5C06 BITMAP \u4E2D\u7684\u6240\u6709\u503C\u7EC4\u5408\u6210 BIGINT \u7C7B\u578B\u7684\u6570\u7EC4\u3002"}),"\n",(0,s.jsx)(t.h2,{id:"\u8BED\u6CD5",children:"\u8BED\u6CD5"}),"\n",(0,s.jsx)(t.pre,{children:(0,s.jsx)(t.code,{className:"language-plaintext",children:" `ARRAY<BIGINT>` BITMAP_TO_ARRAY (bitmap)\n"})}),"\n",(0,s.jsx)(t.h2,{id:"\u53C2\u6570\u8BF4\u660E",children:"\u53C2\u6570\u8BF4\u660E"}),"\n",(0,s.jsxs)(t.p,{children:[(0,s.jsx)(t.code,{children:"bitmap"}),": \u652F\u6301\u7684\u6570\u636E\u7C7B\u578B\u4E3A BITMAP\u3002"]}),"\n",(0,s.jsx)(t.h2,{id:"\u8FD4\u56DE\u503C\u8BF4\u660E",children:"\u8FD4\u56DE\u503C\u8BF4\u660E"}),"\n",(0,s.jsx)(t.p,{children:"\u8FD4\u56DE\u503C\u7684\u6570\u636E\u7C7B\u578B\u4E3A BIGINT \u7C7B\u578B\u7684\u6570\u7EC4\u3002"}),"\n",(0,s.jsx)(t.h2,{id:"\u793A\u4F8B",children:"\u793A\u4F8B"}),"\n",(0,s.jsx)(t.pre,{children:(0,s.jsx)(t.code,{className:"language-Plain",metastring:"text",children:"select bitmap_to_array(bitmap_from_string(\"1, 7\"));\n+----------------------------------------------+\n| bitmap_to_array(bitmap_from_string('1, 7')) |\n+----------------------------------------------+\n| [1,7] |\n+----------------------------------------------+\n\nselect bitmap_to_array(NULL);\n+-----------------------+\n| bitmap_to_array(NULL) |\n+-----------------------+\n| NULL |\n+-----------------------+\n"})})]})}function p(e={}){let{wrapper:t}={...(0,i.R)(),...e.components};return t?(0,s.jsx)(t,{...e,children:(0,s.jsx)(d,{...e})}):d(e)}}}]);
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.