I don't understand what you mean with "two data set". If they are the two file that I gave you, they are both sorted in the same way (reverse chronological).
Please, tell me if I can help you in some way. Il giorno martedì 8 novembre 2016 01:26:55 UTC+1, Sean Beckett ha scritto: > 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, <cslf...@unife.it> 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, <casel...@gmail.com> 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, <cslf...@unife.it> 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 influxdb+u...@googlegroups.com. > > > > > > > > > > > > > > To post to this group, send email to infl...@googlegroups.com. > > > > > > > > > > > > > > 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 influxdb+u...@googlegroups.com. > > > > > > To post to this group, send email to infl...@googlegroups.com. > > > > > > 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 influxdb+u...@googlegroups.com. > > To post to this group, send email to infl...@googlegroups.com. > > 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 influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. 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/e238e4af-ac88-4de3-a9d6-0fb7804157ee%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.