{
"results": [
{
"series": [
{
"name": "metricId_1_intervalId_5",
"columns": [
"time",
"flags",
"forecastOffset",
"intervalId",
"sensorId",
"sign",
"sourceId",
"statId",
"value"
],
"values": [
[
1389574800000000000,
0,
null,
"5",
"132",
"1",
"315",
"0",
152800
],
[
1389574800000000000,
null,
null,
"5",
"132",
"1",
"315",
"0",
152800
],
[
1389575700000000000,
0,
null,
"5",
"132",
"1",
"315",
"0",
160000
],
[
1389575700000000000,
null,
null,
"5",
"132",
"1",
"315",
"0",
160000
]
]
}
]
}
]
}
Am Donnerstag, 9. Februar 2017 22:23:02 UTC+1 schrieb Mark Rushakoff:
>
> The indentation is hard to follow in a variable width font. Can you post
> the JSON output? (i.e. from the influx CLI run `format json` and then your
> query `select * from "metricId_1_intervalId_5" where time >=
> '2014-01-13T01:00:00Z' and sourceId = '315' limit 10`.
>
> It looks like maybe the forecastOffset tag is 0 in half of the points and
> absent in the other half, in which case I believe the system is behaving as
> expected. If it isn't that, are you able to try running with 1.2?
>
> On Thu, Feb 9, 2017 at 10:02 AM, Davis Kirkendall <[email protected]
> <javascript:>> wrote:
>
>> I'm trying to track down some weird behavior in Influxdb 1.1
>>
>>
>> > select * from "metricId_1_intervalId_5" where time >=
>> '2014-01-13T01:00:00Z' and sourceId = '315' limit 10
>>
>> name: metricId_1_intervalId_5
>> -----------------------------
>> time flags forecastOffset intervalId sensorId
>> sign sourceId statId value
>> 1389574800000000000 0 5 132
>> 1 315 0 152800
>> 1389574800000000000 5 132
>> 1 315 0 152800
>> 1389575700000000000 0 5 132
>> 1 315 0 160000
>> 1389575700000000000 5 132
>> 1 315 0 160000
>> 1389576600000000000 0 5 132
>> 1 315 0 183200
>> 1389576600000000000 5 132
>> 1 315 0 183200
>> 1389577500000000000 0 5 132
>> 1 315 0 111200
>> 1389577500000000000 5 132
>> 1 315 0 111200
>> 1389578400000000000 0 5 132
>> 1 315 0 158400
>> 1389578400000000000 5 132
>> 1 315 0 158400
>>
>> The interesting part is that "flags" and "values" are fields, meaning
>> that there should be no way for duplicate points such as [1,2], [3,4] and
>> so on to exist since timestamp and tag set are the same.
>>
>> > show field keys from metricId_1_intervalId_5
>>
>> name: metricId_1_intervalId_5
>> -----------------------------
>> fieldKey fieldType
>> value float
>> flags float
>>
>>
>> Am I missing something or has anyone experienced something comparable
>> before? Could this be some sort of bug with the sharding process?
>>
>>
>> --
>> 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] <javascript:>.
>> To post to this group, send email to [email protected]
>> <javascript:>.
>> 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/85f0e693-33d9-4fca-af79-8c1723d732bb%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/influxdb/85f0e693-33d9-4fca-af79-8c1723d732bb%40googlegroups.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/b445e36f-a507-42d1-89b6-b92843f6123e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
