starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

Convert unnest(bitmap_to_array(xxx)) to unnest_bitmap

Open trueeyu opened this issue 1 year ago • 0 comments

Enhancement

Current users allways use unnest(bitmap_to_array(xxx)) to unnest bitmap.

There are two problems with this usage.

  1. Poor performance and high memory usage.
  2. It will be limited by the length of array.

Current unnest_bitmap(xxx) was supported, and it is best to be able to automatically convert.

trueeyu avatar May 16 '24 11:05 trueeyu