I have found that the results of the bitmap_count() function output differs significantly between databricks and snowflake.
eg: snowflake returns a value of '1' for this code. "select bitmap_count(X'0001056c000000000000') "
![vigneshp_1-1701992518337.png vigneshp_1-1701992518337.png](/t5/image/serverpage/image-id/5532i6E810A7BF2A67477/image-size/medium/is-moderation-mode/true?v=v2&px=400)
while Databricks returns a value of '7' .
![vigneshp_0-1701992493192.png vigneshp_0-1701992493192.png](/t5/image/serverpage/image-id/5531iA39C20BAEC0F4FE1/image-size/medium/is-moderation-mode/true?v=v2&px=400)
does anyone know the reason for this difference? Am I doing anything wrong here? This is part of a migration project.
Similar to the bitmap_count() function , the bitmap_or_agg() function also works differently, it databricks it pads a lot of zeroes at the end.