wwwxxxhhh commented on issue #49877:
URL: https://github.com/apache/doris/issues/49877#issuecomment-2832918098
> 能否提供一些数据和表的schema，我们复现一下你说的问题。 单纯从你的描述上，我们不知道问题在哪里。。。
- 表结构
create table inst_info(
loan_apply_id varchar(100),
busi_belong_inst_no text,
busi_handov_inst_no text,
busi_acc_mng_pers_id text,
create_time text,
upd_time text,
deled_flag text,
xxx xxxx
xxx xxxx
其他倒排索引
INDEX index_4(loan_apply_id) using inverted,
INDEX index_5(deled_flag) using inverted,
)engine=olap
unique key(loan_apply_id)
distributed by hash(loan_apply_id) buckets 10
properties(
"replication_allocation"="tag.location.default:3",
"min_load_replica_num"="-1",
"is_being_synced"= "false",
"storage_format"="V2",
"inverted_index_storage_format"="default"
"enable_unigue_key_merge_on_write"="crue"
"light_schema_change"= "true",
"disable_auto_compaction"= "false"
"enable_single_replica_compaction"="false",
"group_commit_interval_ms"="10000,
"group_commit_data_bycesu="1342.7728,
"eneble_mow_lignt_delete="false"
)
create table record_info(
loan_apply_id varchar(100),
start_dt varchar(100),
end_dt varchar(100),
busi_belong_inst_no text,
busi_acc_mng_pers_id text
)engine=olap
unique key(loan_apply_id,start_dt,end_dt)
distributed by hash(loan_apply_id,start_dt,end_dt) buckets 10
properties(
"replication_allocation"="tag.location.default:3",
"min_load_replica_num"="-1",
"is_being_synced"= "false",
"storage_format"="V2",
"inverted_index_storage_format"="default"
"enable_unigue_key_merge_on_write"="crue"
"light_schema_change"= "true",
"disable_auto_compaction"= "false"
"enable_single_replica_compaction"="false",
"group_commit_interval_ms"="10000,
"group_commit_data_bycesu="1342.7728,
"eneble_mow_lignt_delete="false"
)
- sql以及结果
select
count(1)
from inst_info a
where a.deled flag=0'
and not exists (select '1' from record_info b where a.loan_apply_id =
b.loan_apply_id)
返回值：0
select
count(1)
from inst_info a
where a.deled flag=0'
and a.loan_apply_id not in (select b.loan_apply_id from record_info b )
返回值：11542969
select
count(1)
from inst_info a
where a.deled flag=0'
and a.loan_apply_id not in (select distinct b.loan_apply_id from record_info
b )
返回值：12115347
select
count(1)
from inst_info a
where a.deled flag=0'
and a.loan_apply_id not in (select b.loan_apply_id from record_info b group
by b.loan_apply_id)
返回值：0
- 表数据量
- inst_info : 84335098
- record_info : 180147745
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
