I had a hunch it was data-specific. I have no guesses as to why, though. Thanks for doing the follow-up research and filing the issue!
On Thu, Nov 3, 2016 at 2:07 PM, Jeroen Coussement < jeroen.coussem...@gmail.com> wrote: > Just upgraded, issue persists. The strange thing is that I have a second > database on the same server and on that database the results are as > expected. I'll open an issue. > > Thanks! > > On 3 November 2016 at 17:58, Sean Beckett <s...@influxdb.com> wrote: > >> Jeroen, >> >> I recommend upgrading to 1.0.2, since I don't see this behavior with that >> version. If that doesn't solve it, please open an issue >> <https://github.com/influxdata/influxdb/issues/new> on GitHub, as that >> is not the expected behavior. >> >> On Wed, Nov 2, 2016 at 11:38 PM, Jeroen Coussement < >> jeroen.coussem...@gmail.com> wrote: >> >>> OK, pretty results here. >>> >>> (If you would want access to the server to check yourself, you can give >>> me an emailaddress, I can send you a link and a login) >>> >>> The result of the aboce query (in pretty) is this: >>> >>> { >>> "results": [ >>> { >>> "series": [ >>> { >>> "name": "valve_state", >>> "columns": [ >>> "time", >>> "count_value" >>> ], >>> "values": [ >>> [ >>> "2016-10-30T06:35:38.436577584Z", >>> 1414 >>> ] >>> ] >>> } >>> ] >>> } >>> ] >>> } >>> >>> >>> while SHOW FIELD KEYS returns this: >>> >>> { >>> "results": [ >>> { >>> "series": [ >>> { >>> "name": "RPi_distance", >>> "columns": [ >>> "fieldKey", >>> "fieldType" >>> ], >>> "values": [ >>> [ >>> "value", >>> "float" >>> ] >>> ] >>> }, >>> { >>> "name": "RPi_humidity", >>> "columns": [ >>> "fieldKey", >>> "fieldType" >>> ], >>> "values": [ >>> [ >>> "value", >>> "float" >>> ] >>> ] >>> }, >>> { >>> "name": "RPi_temperature", >>> "columns": [ >>> "fieldKey", >>> "fieldType" >>> ], >>> "values": [ >>> [ >>> "value", >>> "float" >>> ] >>> ] >>> }, >>> { >>> "name": "events", >>> "columns": [ >>> "fieldKey", >>> "fieldType" >>> ], >>> "values": [ >>> [ >>> "text", >>> "string" >>> ] >>> ] >>> }, >>> { >>> "name": "fill_level", >>> "columns": [ >>> "fieldKey", >>> "fieldType" >>> ], >>> "values": [ >>> [ >>> "value", >>> "float" >>> ] >>> ] >>> }, >>> { >>> "name": "flow_rate", >>> "columns": [ >>> "fieldKey", >>> "fieldType" >>> ], >>> "values": [ >>> [ >>> "value", >>> "float" >>> ] >>> ] >>> }, >>> { >>> "name": "pump_speed", >>> "columns": [ >>> "fieldKey", >>> "fieldType" >>> ], >>> "values": [ >>> [ >>> "value", >>> "float" >>> ] >>> ] >>> }, >>> { >>> "name": "testvalue", >>> "columns": [ >>> "fieldKey", >>> "fieldType" >>> ], >>> "values": [ >>> [ >>> "value", >>> "float" >>> ] >>> ] >>> }, >>> { >>> "name": "valve_state", >>> "columns": [ >>> "fieldKey", >>> "fieldType" >>> ], >>> "values": [ >>> [ >>> "value", >>> "boolean" >>> ] >>> ] >>> } >>> ] >>> } >>> ] >>> } >>> >>> >>> On 3 November 2016 at 01:29, Sean Beckett <s...@influxdb.com> wrote: >>> >>>> Jeroen, can you use the CLI >>>> <http://docs.influxdata.com/influxdb/v1.0/tools/shell/> or turn on pretty >>>> output >>>> <https://docs.influxdata.com/influxdb/v1.0/guides/querying_data/#querying-data-using-the-http-api> >>>> for the HTTP API so it's easier to see the data? >>>> >>>> On my OSS 1.0.2 server the query returns results for every measurement, >>>> as expected. >>>> >>>> What's the output from SHOW FIELD KEYS? >>>> >>>> On Wed, Nov 2, 2016 at 5:48 PM, <jeroen.coussem...@gmail.com> wrote: >>>> >>>>> I have a testDB (InfluxDB v1.0.0 on Ubuntu 16.04) with different >>>>> measurements. I want to count all points between two timestamps, so the >>>>> influx support team suggested this query: >>>>> >>>>> SELECT COUNT(*) FROM /.*/ WHERE time > now() - 4d AND time < now() >>>>> >>>>> When I run this on my DB, i only get the count from 1 measurement: >>>>> >>>>> {"results":[{"series":[{"name":"valve_state","columns":["tim >>>>> e","count_value"],"values":[["2016-10-29T23:44:44.327400928Z >>>>> ",1404]]}]}]} >>>>> >>>>> However. I have plenty more data between those dates. If i just >>>>> replace the wildcard with an actual measurement name, i get: >>>>> >>>>> {"results":[{"series":[{"name":"fill_level","columns":["time >>>>> ","count_value"],"values":[["2016-10-29T23:46:19.746417968Z" >>>>> ,1728000]]}]}]} >>>>> >>>>> Any ideas on what is wrong here? >>>>> >>>>> -- >>>>> 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/abfbb2c9-7b28-4dd >>>>> a-93c0-5f111c03d3aa%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 a topic in the >>>> Google Groups "InfluxData" group. >>>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>>> pic/influxdb/ly56NzwnP0c/unsubscribe. >>>> To unsubscribe from this group and all its topics, 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/ms >>>> gid/influxdb/CALGqCvO4MFPWTRCGjoLza-Pjafw_Srf%2BNtGco25khNjP >>>> qGS0Rw%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/influxdb/CALGqCvO4MFPWTRCGjoLza-Pjafw_Srf%2BNtGco25khNjPqGS0Rw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >>> 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/ms >>> gid/influxdb/CABHhaKCeTtWtAuDkwMGODMP3aZU%3DWUiivgdXhzAjg2Rh >>> SJLUTQ%40mail.gmail.com >>> <https://groups.google.com/d/msgid/influxdb/CABHhaKCeTtWtAuDkwMGODMP3aZU%3DWUiivgdXhzAjg2RhSJLUTQ%40mail.gmail.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 version number! >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "InfluxData" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/to >> pic/influxdb/ly56NzwnP0c/unsubscribe. >> To unsubscribe from this group and all its topics, 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/ms >> gid/influxdb/CALGqCvMk1fZwBZvKUOrJF2SVJbOw8bQtOGMsiH90QWEa0H >> 520A%40mail.gmail.com >> <https://groups.google.com/d/msgid/influxdb/CALGqCvMk1fZwBZvKUOrJF2SVJbOw8bQtOGMsiH90QWEa0H520A%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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/ms > gid/influxdb/CABHhaKCevUSC_msqETVspbFnRL%2BKbMZhTexAvvNO%2B7 > UdD3MdQw%40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CABHhaKCevUSC_msqETVspbFnRL%2BKbMZhTexAvvNO%2B7UdD3MdQw%40mail.gmail.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 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/CALGqCvO%3DMDE%2BLiO6FtE_xCeYQz_5QbLDwKypP6ej8dV6VNhBVg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.