Combine old data with new data and overwrite #11804
Description
Affected Version
0.22.0
Description
I'm following the tutorial for updating existing data by using the quick-start scripts. In the 3rd step, I should be able to combine old data from data source with the new data from the JSON. However, the end result is not quite like how it is shown in the docs. According to the docs, I should get "aadvark", "bear" from old data as well as rolled-up "lion". However, I'm getting the results below.
dsql> select * from "updates-tutorial";
┌──────────────────────────┬──────────┬───────┬────────┐
│ __time │ animal │ count │ number │
├──────────────────────────┼──────────┼───────┼────────┤
│ 2018-01-01T01:01:00.000Z │ lion │ 1 │ 300 │
│ 2018-01-01T05:01:00.000Z │ mongoose │ 1 │ 737 │
│ 2018-01-01T06:01:00.000Z │ snake │ 1 │ 1234 │
│ 2018-01-01T07:01:00.000Z │ octopus │ 1 │ 115 │
└──────────────────────────┴──────────┴───────┴────────┘
It looks like instead of combining the old and new data, it just overwrites entire segment with new data. I'm not sure if this is the expected behaviour of the combining inputSource or there is a bug.