[GitHub] [druid] paul-rogers commented on issue #11929: Batch ingestion using SQL INSERT

[GitBox <gi...@apache.org>]

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: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org