📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

SUB_BITMAP



Generates a sub-bitmap of the source bitmap, beginning from the start index, with a specified size.

Syntax

SUB_BITMAP( <bitmap>, <start>, <size> )

Examples

SELECT SUB_BITMAP(BUILD_BITMAP([1, 2, 3, 4, 5]), 1, 3)::String; ┌─────────────────────────────────────────────────────────┐ │ sub_bitmap(build_bitmap([1, 2, 3, 4, 5]), 1, 3)::string │ ├─────────────────────────────────────────────────────────┤ │ 2,3,4 │ └─────────────────────────────────────────────────────────┘

Was this page helpful?