Apache Druid

Hi Dejanz,

In general you can update and/or delete records in Druid by reingesting data for specific time intervals using insert/overwrite mode. You do have to replace all of the data in the time internal in its entirety though, so you have to carry forward all unchanged data in the time interval during the reingestion.

Using MSQ SQL (you can use Native as well, but I prefer to use SQL because it's easier to write and read) you could do some form of reingestion like this:

```replace into datasource overwrite all
 select * from datasource
  where (origination, destination) in (
         select origin, destination from datasource group by 1, 2 having sum(seizures) != 0
        )
partitioned by DAY```
You do not have to overwrite "all" ... you can select a specific time internal that matches your segment granularity but you would have to make sure that all records you want to omit are completely in that time interval.

Let us know if you have questions.

Thanks. John