# Data getting double in target table
**URL:** https://discuss.elastic.co/t/data-getting-double-in-target-table/207041
**Category:** Logstash
**Created:** [November 8, 2019, 4:29am UTC](https://discuss.elastic.co/t/data-getting-double-in-target-table/207041 "2019-11-08T04:29:34Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Sumati\_Jain](https://discuss.elastic.co/u/Sumati_Jain)
#### Post date: [November 8, 2019, 4:29am UTC](https://discuss.elastic.co/t/data-getting-double-in-target-table/207041/1 "2019-11-08T04:29:34Z")
Hi everyone,
I'm fetching data from Elasticsearch and putting into Bigquery through Logstash pipeline.
When I'm fetching 15 days of data then I'm getting same number of records as source. No issues with 15 days of data.
However, when I'm fetching data for 1.5 months, my data is getting double and triple in the target BQ table.
I'm using below query:
"query":
{
"range" : {
"timestamp" : {
"gte" : "2019-04-16",
"lte" : "2019-05-31"
}
}
}
I'm not sure whether my query is correct to pull data from ES and put into BQ or not.
In kibana, above query is working fine. But when I'm pulling data through Logstash with same query, then data is getting double.
Could anyone advice me on this issue.
Thanks in advance!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 6, 2019, 4:29am UTC](https://discuss.elastic.co/t/data-getting-double-in-target-table/207041/2 "2019-12-06T04:29:35Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.