LIMIT limits the number of values returned, not the number of points sampled. With an aggregation function like COUNT(), there is only one value returned for all the points sampled. LIMIT 10 has no meaning since there's only one result to return. You will get the same output if you leave the LIMIT clause off.
So, you have 11 points with an "unacked" field, and then over time more points match and the number rises. On Mon, Jul 18, 2016 at 8:32 PM, <[email protected]> wrote: > Hi, > I'm new to Influxdb, and using 13.0. > I create a database with 30d duration, 1d shardGroupDuration, 1 replicat > and one measurement. The measurement has 4 tags(machinename, queue_type, > vhost, queuename) and 5 values(consumers, ready, unacked, enqueued, > dequeued). > First i query "select * from mqMetric where queue_type = 'ACTIVEMQ' > limit 10", and get 10rows. Then, query "select count(unacked) from mqMetric > where queue_type = 'ACTIVEMQ' limit 10", it return different values. At the > beginning, it returns 11. Then, writing data for about 4 days, it returns > 44. As there are some data with different tags in the measurement, so i > wonder if this make the problem, and i drop the measurement, restart > writing data to it. Again, It returns 11 at the beginning, and one day > later, it returns 22. > I'm confused about the result. Why it changed by day or by the number of > data in the measurement? or it's a bug? > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" 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/25fb92b7-60ab-4284-ab7f-3ebded6f4555%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/25fb92b7-60ab-4284-ab7f-3ebded6f4555%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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/CALGqCvPGcPLHbjUQqi5vacieZBzv18T9bGiCCNovb3kbrdKj0w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
