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 < [email protected]> 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 <[email protected]> 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, <[email protected]> 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 [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/ms >>> gid/influxdb/abfbb2c9-7b28-4dda-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 >> [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/ms >> gid/influxdb/CALGqCvO4MFPWTRCGjoLza-Pjafw_Srf% >> 2BNtGco25khNjPqGS0Rw%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 [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/CABHhaKCeTtWtAuDkwMGODMP3aZU%3DWUiivgdXhzAjg2RhSJLUTQ% > 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 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/CALGqCvMk1fZwBZvKUOrJF2SVJbOw8bQtOGMsiH90QWEa0H520A%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
