删除语句执行6小时

Viewed 28

审计日志:
2025-05-24 05:41:27,239 [query] |Client=10.1.106.158:17916|User=root|Ctl=internal|Db=tsib|State=OK|ErrorCode=0|ErrorMessage=|Time(ms)=21600464|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=8388309|QueryId=d9defb8d8f5c4afb-bf38eb1f3b7c4c8c|IsQuery=false|IsNereids=true|FeIp=10.1.106.156|Stmt=\ndelete\nfrom dws_marketing_sale_delivery_customized_d_in\nwhere day_time >= '2025-03-01 00:00:00'\n and data_flag = 'online'\n and data_source = 'HHJYBF';|CpuTimeMS=0|ShuffleSendBytes=-1|ShuffleSendRows=-1|SqlHash=6b6251acfaca98cf3a354ae7f082c6ea|PeakMemoryBytes=0|SqlDigest=|WorkloadGroup=|FuzzyVariables=

1 Answers

delete操作在Doris里是很重的操作,尤其你delete大量数据的时候,会影响查询。如果你要删数据,可以使用基于导入的__DORIS_DELETE_SIGN__隐藏列的方式。https://doris.apache.org/zh-CN/docs/data-operate/delete/batch-delete-manual?_highlight=doris_delete_sign#%E5%8E%9F%E7%90%86%E8%AF%B4%E6%98%8E