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/
> 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/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.
For more options, visit https://groups.google.com/d/optout.
