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 <[email protected]> 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 < > [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%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 [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/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/ > topic/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/ > msgid/influxdb/CALGqCvMk1fZwBZvKUOrJF2SVJbOw8bQtOGMsiH90QWEa0H520A%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 [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/CABHhaKCevUSC_msqETVspbFnRL%2BKbMZhTexAvvNO%2B7UdD3MdQw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
