JackTan25

Results 17 issues of JackTan25

## General Question I mean the sql statement like this: Select t1.a,t2.b from t1 join t2 on t1.c = t2.d and t1.e > t2.f; how to use hash join to...

type/question

![a](https://user-images.githubusercontent.com/60096118/119169376-838e4f80-ba94-11eb-90f8-34409259ef66.png) 这个是那个HeapFile类里面(那个write只是把空白页写入了,但是调用的HeapPage的insertTuple也只是将tuple写到了HeapPage对象里面,没有将这个tuple写到硬盘上,所以何时才是真的该写入了呢??)

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/ ## Summary PartitialFullOuter is an optimization for merge into source build, in this case, we can do pass...

pr-feature

Merge Into is supported by #12350, but it's not completed. We have many things to do. A basic implemention : ## Optimizations - [ ] merge into in distributed mode...

C-feature

**Summary** For now in databend, there is no a good way to make sure the data unique constraint. We need to support an Index for storage engine and support feature...

C-feature

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/ ## Summary _Briefly describe what this PR aims to solve. Include background context that will help reviewers understand...

pr-feature

**Summary** In Pr https://github.com/datafuselabs/databend/pull/14066, we support block info hash table optimization for merge into. But in fact, it doesn't native engine. for now, we disable target_table_optimization for native. Native will,spilt...

C-feature

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/ ## Summary We add target table block bloom filter for merge into runtime filter, so we can avoid...

pr-feature
ci-cloud

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/ ## Summary if the machine has too many cores, maybe we will write too many small block, which...

pr-chore
ci-cloud

**Summary** We can use runtime filter's bloom index to do collision with parquet block's bloom filter index to do prune in storage level. When do parquet reading, we can improve...

C-feature