# Merge duplicate data points

**URL:** <https://community.influxdata.com/t/merge-duplicate-data-points/3994>\
**Category:** Telegraf\
**Tags:** influxdb, time-series\
**Created:** [February 13, 2018, 4:21pm UTC](https://community.influxdata.com/t/merge-duplicate-data-points/3994 "2018-02-13T16:21:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![b989](https://avatars.discourse-cdn.com/v4/letter/b/5daacb/32.png) [@b989](https://community.influxdata.com/u/b989)\
**Post date:** [February 13, 2018, 4:21pm UTC](https://community.influxdata.com/t/merge-duplicate-data-points/3994/1 "2018-02-13T16:21:11Z")

</div>

Hi,

We have a periodic task that runs every 1 hour and fetch data from our warehouse of (48h) and push them to influxdb, this leads to duplicate data points, is there a way to merge/update/upsert/overwrite on influxdb ?

Thanks

---

<div class="post-metadata">

**Author:** ![sbains](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@sbains](https://community.influxdata.com/u/sbains)\
**Post date:** [February 14, 2018, 7:30am UTC](https://community.influxdata.com/t/merge-duplicate-data-points/3994/2 "2018-02-14T07:30:27Z")

</div>

If the timestamp and tag values are same, the entries will be overwritten. Majority of the time it is the timestamp but it can also be the incorrect schema.

---

<div class="post-metadata">

**Author:** ![b989](https://avatars.discourse-cdn.com/v4/letter/b/5daacb/32.png) [@b989](https://community.influxdata.com/u/b989)\
**Post date:** [February 14, 2018, 9:42am UTC](https://community.influxdata.com/t/merge-duplicate-data-points/3994/3 "2018-02-14T09:42:04Z")

</div>

Thanks! is this a standard behaviour in all influxdb versions? we are using 1.2.4

---

<div class="post-metadata">

**Author:** ![sbains](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@sbains](https://community.influxdata.com/u/sbains)\
**Post date:** [February 14, 2018, 5:01pm UTC](https://community.influxdata.com/t/merge-duplicate-data-points/3994/4 "2018-02-14T17:01:38Z")

</div>

I been using it since version 0.9 and have same experience when overwriting the data.