HappenLee opened a new issue #5358:
URL: https://github.com/apache/incubator-doris/issues/5358


   ## Motivation
   At present,  Doris support `delete statement`
   
   For example,  ```delete table test where a = 10```
   
   Now Doris support an asynchronous delete operation,data will be filtered in 
query. But Now Delete condition filter data slowly. We need a better way to do 
some thing.
   
   
   ## How column predicate replace detele condition
   
   
![image](https://user-images.githubusercontent.com/10553413/106855172-7a50c100-66f7-11eb-8f52-4cffc759fd75.png)
   
   it make storage engine delete data early
   
   ### It can bring us the following benefits:
   
   
   1. First, we can filter data more early, it make storage engine save mem and 
cpu to do unless work.
   
   2. Secondly, segment v2 can use delete condition to do `Lazy Materization` 
which will reduce IO of Storange greatly.
   
   3. Last, the data filter in column predicate it eazy for compiler to do 
`Query Verctorion`.
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to