JackTan25

well, in fact, snowflake has a unique store (https://www.snowflake.com/en/data-cloud/workloads/unistore/). They are developing it, but we can't get the source code and design details. But we can still find out some...

> We can investigate how snowflake implement this (data unique constraint), and I have a question: is ART Tree suitable for object storage ? for now, they don't support.

> > > We can investigate how snowflake implement this (data unique constraint), and I have a question: is ART Tree suitable for object storage ? > > > >...

> Is ART Tree suitable for object storage ? I think this question is very important, because Databend is not a memory or disk oriented database. good question, give a...

cc @dantengsky

https://openproceedings.org/2023/conf/edbt/paper-190.pdf for https://github.com/datafuselabs/databend/pull/14970, we find out that in some cases, the false positive is very high, so we can't prune blocks as expected. We introduce BloomRF to solve this which...

Let's hold on this, I find a bug on cloud test. @dantengsky @xudong963

distributed_wizard_test: Passed Click me ```sql Preparing to run MERGE-INTO-C1... Executing command: bendsql --query=-- MERGE-INTO-C1: Asset Types Distribution SELECT asset_type, COUNT(*) AS count FROM assets GROUP BY asset_type ORDER BY count...

standalone_wizard_standalone_test(in distributed cluster): Passed Click me ```sql Preparing to run MERGE-INTO-C1... Executing command: bendsql --query=-- MERGE-INTO-C1: Asset Types Distribution SELECT asset_type, COUNT(*) AS count FROM assets GROUP BY asset_type ORDER...

source_build_distributed_update_optmization_pk_bloom: Passed Click me ```sql Preparing to run Unknown Query... Executing command: bendsql --query=-- test lineitem_target_origin_200_blocks1 table -- 1. Basic Statistics Query SELECT COUNT(*) as total_records, AVG(l_quantity) as avg_quantity, MAX(l_extendedprice)...