Can anyone help me figure out this issue? I restructured my database, and have to fill in historical data into the new format. For some reason, the historical data comes out in a different table when I query it, even though all the values in the group key are identical. If I call group() using the s…

I tried calling distinct on each of my columns in the group key to see if there was some formatting difference between some of the values, but I get this error, presumably because there are two tables with the same group key values. runtime error @8:6-8:30: unique: unique found duplicate table with…

Curiously, when graphing, I only get one color line in the graph, as if it’s a single series, (which of course it should be,) but it connects the beginning to the end in a loop. [image] EDIT: Not quite a full loop. It is a single line, but there is a break between the old and new data when I zoom…

If I run group on the same group key, then sort, I now get just one table and the correct graph. I tried piping that query to the same bucket, to overwrite the existing data, but that didn’t help anything.

And now some more weirdness, which perhaps helps figure out what is going on here? While trying to unify the points, I somehow got two points into the same bucket with the same time and tags (but are somehow part of different series.) I thought that when adding a point with the same time and tag it …

Hello @gazpachoking , I thought so too. This is very strange behavior. Can you please create an issue here? [image] GitHub - influxdata/influxdb: Scalable datastore for metrics, events, and... Scalable datastore for metrics, events, and real-time analytics - GitHub - influxdata/influxd…

Created an issue here Points in the same series being returned in separate tables (plus duplicate points with _all_ values matching) · Issue #24127 · influxdata/influxdb · GitHub

Nope, didn’t notice it got solved, I resorted to just manually running group and sort on every query to make sure I only got one table.

[image] gazpachoking: didn’t notice it got solved In fact it has NOT been solved, the issue is still opened.

Two tables returned with identical group keys

InfluxDB 2

virtualdj July 8, 2023, 6:54pm 8

I probably have the same issue here. Were you able to solve? It seems the issue is still opened in GitHub…

Topic		Replies	Views
Unexpected duplicate values InfluxDB 2	0	413	July 24, 2023
Duplicate values stored in database Store influxdb	6	625	May 27, 2019
Selecting multiple measurements result in multiple tables for the same measurements InfluxDB 2 grafana	0	998	July 20, 2019
Transform multiple tables into just one InfluxDB 2 flux	2	3754	May 22, 2022
Help with querying several fields from the same point InfluxDB 2	1	379	November 2, 2020

Two tables returned with identical group keys

Related topics