techdocsmith commented on code in PR #16081: URL: https://github.com/apache/druid/pull/16081#discussion_r1518165023
########## docs/tutorials/tutorial-update-data.md: ########## @@ -23,161 +23,236 @@ sidebar_label: Update existing data ~ under the License. --> +:::info -This tutorial shows you how to update data in a datasource by overwriting existing data and adding new data to the datasource. +Apache Druid supports two query languages: [Druid SQL](../querying/sql.md) and [native queries](../querying/querying.md). +This document describes the SQL language. + +::: + +Apache Druid stores data and indexes in [segment files](../design/segments.md) partitioned by time. +Once segments are created, they cannot be modified. +To update existing data, you must rebuild and republish the segments. +Druid updates existing data using time ranges, not primary key. Data outside the replacement time range is not touched. Review Comment: I would also add here: You can use this functionality in Druid to perform data updates, inserts, and deletes, similar to UPSERT functionality for transactional databases. (we need to have UPSERT mentioned somewhere) -- 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-unsubscr...@druid.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org For additional commands, e-mail: commits-h...@druid.apache.org