{ "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 <davis.e.k...@gmail.com > <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 influxdb+u...@googlegroups.com <javascript:>. >> To post to this group, send email to infl...@googlegroups.com >> <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 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/b445e36f-a507-42d1-89b6-b92843f6123e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.