sundyli

> @sundy-li Currently, function `in` has signature `in(, list_0, list_1, ....)`. Can we change it to `array_contains(T, Array(T))`? Therefore, `a IN (1, 2, 3)` will be desugured into `array_contains(a, array_construct(1,...

See the comments in: https://github.com/datafuselabs/databend/blob/fc868936df12e06f5c907c335ac813e950c3eb8b/src/query/functions-v2/tests/it/main.rs

it's in progress #1304

closed in #9411

Let's add pgwrite into databend!

@suimenno3002 Great summary. Your analysis is almost correct. I think it's better to have **equal-height histogram** which avoids the skew problem and accurate results. We don't have this implementation now....

@suimenno3002 are you working on this issue? If not we will assign it to our inner developer to have this issue because we need this feature in recent updates.

Yes, you can submit a draft pr indicates that you are working on this. > does this version need to support string type aggregate? Yes. For numeric and string type,...

@imsnif let me try it!

> I don't know yet what the shuffle is about. I don't know the detail either but looks like it will use some SIMD instructions to improve copy performance. https://doc.rust-lang.org/beta/core/arch/x86_64/fn._mm_shuffle_epi8.html...