There's something going on but I need to make a simpler repro case to fully characterize it.
For one thing, the counts come out correct when there's an explicit upper bound to the query. The other thing is that the two data sets are sorted differently. The first is chronological, the second is reverse chronological. When I sort the second chronologically before writing, there are no issues with the COUNT, whether or not there is an upper bound. On Fri, Nov 4, 2016 at 3:13 AM, <[email protected]> wrote: > Of course, these are the files with raw data: > > https://www.dropbox.com/s/6r5ebcyl8xv7y1x/data_for_influxdb.txt?dl=0 > https://www.dropbox.com/s/h1num78wn9y54eu/data_for_influxdb_1.txt?dl=0 > > Il giorno giovedì 3 novembre 2016 18:27:03 UTC+1, Sean Beckett ha scritto: > > Without the raw data we can't recreate it. Can you upload the raw points > to a gist, perhaps? > > > > > > On Thu, Nov 3, 2016 at 9:46 AM, <[email protected]> wrote: > > I tried to upload the same data in a different computer with influxdb > v0.13 installed and all works. > > > > > > > > I think is an issue of influx new version. > > > > > > > > > > > > > > > > Il giorno mercoledì 2 novembre 2016 17:57:33 UTC+1, Sean Beckett ha > scritto: > > > > > > > > > On Wed, Nov 2, 2016 at 7:57 AM, <[email protected]> wrote: > > > > > Hi all, > > > > > > > > > > after upgrading influxdb from 0.13 to 1.0 I notice some problems when > I insert data with identical measurement name, tag and timestamp writing > multiple points from different files: with old version the points were > overwritten but now points are duplicate. > > > > > > > > > > > > > > > > > > > > There is no change in behavior between 0.13 and 1.0 when it comes to > duplicate measurement, tagset and timestamps. The duplicates are stored as > the union of the field sets, but the overall point count would be the same. > > > > > The files that I used is of this type: > > > > > > > > > > cumulato,matricola_contatore=1012-008-5647 value=85.627 > 1476286500000000000 > > > > > > > > > > cumulato,matricola_contatore=1012-008-5647 value=85.627 > 1476286200000000000 > > > > > > > > > > cumulato,matricola_contatore=1012-008-5647 value=85.627 > 1476285900000000000 > > > > > > > > > > (...) > > > > > > > > > > > > > > > > > > > > The files contain one value from 291 different sources every 5 minutes > so every day I should have 83808 (291*24*12) points. > > > > > > > > > > I insert data in two different moments and the time series have 5 days > during which they overlap. > > > > > > > > > > > > > > > > > > > > This is the result of the query SELECT COUNT(value) FROM cumulato > WHERE time>='2016-10-01T00:00:00Z' AND time<='2016-10-25T23:55:00Z' GROUP > BY time(1d) > > > > > > > > > > > > > > > > > > > > name: cumulato > > > > > > > > > > -------------- > > > > > > > > > > time count > > > > > > > > > > 1475280000000000000 83808 > > > > > > > > > > 1475366400000000000 83808 > > > > > > > > > > 1475452800000000000 83808 > > > > > > > > > > 1475539200000000000 83808 > > > > > > > > > > 1475625600000000000 83808 > > > > > > > > > > 1475712000000000000 83808 > > > > > > > > > > 1475798400000000000 83808 > > > > > > > > > > 1475884800000000000 85175 > > > > > > > > > > 1475971200000000000 103426 > > > > > > > > > > 1476057600000000000 126510 > > > > > > > > > > 1476144000000000000 130752 > > > > > > > > > > 1476230400000000000 106096 > > > > > > > > > > 1476316800000000000 83983 > > > > > > > > > > 1476403200000000000 83808 > > > > > > > > > > 1476489600000000000 83808 > > > > > > > > > > 1476576000000000000 83808 > > > > > > > > > > 1476662400000000000 83808 > > > > > > > > > > 1476748800000000000 83808 > > > > > > > > > > 1476835200000000000 83808 > > > > > > > > > > 1476921600000000000 83808 > > > > > > > > > > 1477008000000000000 83808 > > > > > > > > > > 1477094400000000000 83808 > > > > > > > > > > 1477180800000000000 83808 > > > > > > > > > > 1477267200000000000 83808 > > > > > > > > > > 1477353600000000000 83808 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > How can I solve this issue? > > > > > > > > > > > > > > > > > > > > For some reason, the points are distinct. Either they have distinct > measurements, tag sets, or timestamps. I recommend looking at the raw data > from those days to determine what is not as expected. > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > Remember to include the version number! > > > > > > > > > > --- > > > > > > > > > > You received this message because you are subscribed to the Google > Groups "InfluxData" group. > > > > > > > > > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected]. > > > > > > > > > > To post to this group, send email to [email protected]. > > > > > > > > > > Visit this group at https://groups.google.com/group/influxdb. > > > > > > > > > > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/be14a610-7e56-4022-9a35-62762d41ff37%40googlegroups.com. > > > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > Sean Beckett > > > > > Director of Support and Professional Services > > > > > InfluxDB > > > > > > > > -- > > > > Remember to include the version number! > > > > --- > > > > You received this message because you are subscribed to the Google > Groups "InfluxData" group. > > > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected]. > > > > To post to this group, send email to [email protected]. > > > > Visit this group at https://groups.google.com/group/influxdb. > > > > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/307b1b37-6238-4d5a-8767-4f2680a7dfad%40googlegroups.com. > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > -- > > > > > > Sean Beckett > > Director of Support and Professional Services > > InfluxDB > > -- > Remember to include the version number! > --- > You received this message because you are subscribed to the Google Groups > "InfluxData" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/aff4ca3b-fea2-422a-8aa6-d7b9076b28ee%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvNWHGaP3agHiHPbpt6CaN8wt0HHDhRX3_9oqs-tJ_72qg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
