Influxdb error querying multiple measurement

InfluxDB 2
1

I am trying to query multiple measurement in same query in influxdb. The result returned usually come from just one table, when I run the queries individually I get result when I run all, I get result for just one measurement eg.
Q1= from (bucket:“example)
|> range(start:30d)
|> filter(fn: (r) => r[“tag”] == “blah”)
|> filter(fn: (r) => r[”_measurement"] == “ghgh” )
|> filter(fn: (r) => r["_field"] == “gggg” )
|> aggregateWindow(every: 1s, fn: first, createEmpty: true)
|> fill(usePrevious: true)
|> yield(“first_table”)

Q2= from (bucket:“example)
|> range(start:30d)
|> filter(fn: (r) => r[“tag”] == “blah”)
|> filter(fn: (r) => r[”_measurement"] == “hjjjj” )
|> filter(fn: (r) => r["_field"] == “ffff” )
|> aggregateWindow(every: 1s, fn: first, createEmpty: true)
|> fill(usePrevious: true)
|> yield(“second_table”)

Q3= from (bucket:“example)
|> range(start:30d)
|> filter(fn: (r) => r[“tag”] == “blah”)
|> filter(fn: (r) => r[”_measurement"] == “yyyy” )
|> filter(fn: (r) => r["_field"] == “fdfdfd” )
|> aggregateWindow(every: 1s, fn: first, createEmpty: true)
|> fill(usePrevious: true)
|> yield(“third_table”)

running this type of query returns just one of the query, however running them separately yields result for the three queries, join doesnot work either

2

Hi @mofolu,
For performance reasons always start with your measurement. Other than that your query is fine. What UI component are you using to visualise the table?

3

I switched to using tags first cause I read it was faster performance wise, thanks for the update. I am using influxdb UI

4

Hi @mofolu,
What UI visualisation type are you using though? (table, graph, etc.). Also what version of InfluxDB are you using? :slight_smile:

5

I am using a table.
Influxdb 2.0.9

6

@mofolu
could you upgrade to 2.2 and check the raw table view instead. We can then see if this is just a bug with 2.0.9’s table UI.