paul-rogers commented on issue #11929:
URL: https://github.com/apache/druid/issues/11929#issuecomment-1092024149
What Druid does is similar to the pair of SQL statements:
```sql
DELETE FROM myTable WHERE ...;
INSERT INTO myTable
SELECT ... FROM myInput WHERE ...;
```
In SQL, one could wrap the above in a transaction to make it atomic. Druid
does not have transactions (nor should it, being a distributed system.) So the
`REPLACE` is a merger of these two ideas:
```sql
REPLACE myTABLE
WHERE ... -- From DELETE
SELECT ... FROM myInput WHERE ... -- From INSERT
```
--
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]
