gianm commented on issue #11929: URL: https://github.com/apache/druid/issues/11929#issuecomment-1097009985
> @gianm - can you elaborate more on how "DELETE WHERE" is a better clause than just "WHERE" clause? @abhishekagarwal87 It's for the reasons in this comment: https://github.com/apache/druid/issues/11929#issuecomment-1090587695 In particular, this part: > It seems potentially confusing that the query could have two WHEREs in it — one for the REPLACE and one for the SELECT — with different meanings. It makes it easy for users to make the mistake of writing this query: Additionally, it makes the documentation harder to write: we'll need to use phrases like "the WHERE on REPLACE" to differentiate it from the WHERE on SELECT. With DELETE WHERE we would be OK calling it "DELETE WHERE" in the docs. For example: > The WHERE attached to REPLACE controls which existing data will be replaced. All data matching this filter will be deleted and replaced with new data. vs. > DELETE WHERE controls which existing data will be replaced. All data matching this filter will be deleted and replaced with new data. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
