morningman commented on issue #4051: URL: https://github.com/apache/incubator-doris/issues/4051#issuecomment-666876657
> I have some question about this proposal. > > 1. Doris is a OLAP system which should be read optimized, however this batch delete proposal is write optimized. > 2. When user want to delete one row, primary key is enough to delete one row. It is unreasonable for user to give all columns for rows to be deleted. > 3. When this is supported, how about materialized view's udpating. > > I think delete is a key feature in a database system, we should discuss enough before doing it. 1. Currently Doris is implemented based on the `Merge on Read` method. This implementation method is the same as the current implementation strategy. 2. In principle, users do not need to provide a value column, this function can support users not to specify a value column. One purpose of this function is to receive the change data sent from the TP database, which is usually the entire line of content. 3. This function is only for the table of the unique key model, and has nothing to do with the materialized view ---------------------------------------------------------------- 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: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
