Hi, Laurent

> Basically, I need to deduplicate, but only keeping in the deduplication state 
> the latest value of the changed column to compare with. While here it seems 
> to keep all previous values…

You can use ` ORDER BY proctime() DESC`  in the deduplication query,  it will 
keep last row, I think that’s what you want.

BTW, the deduplication has supported event time in 1.12, this will be available 
soon.

Best,
Leonard

Reply via email to