Influx fails to query two measurements

1 
#InfluxDB version: 1.7.6
  • fails to display input_2 when I select both measurements
> SELECT "input_1", "input_2"  FROM power LIMIT 2
name: power
time                input_1                        input_2
----                ------------------------------ ---------------
1559178870000000000 3415
1559178870000000000 1795
  • Works with last() # need it work with out last()
SELECT last("input_1"), last("input_2")  FROM power
name: power
time last last_1
---- ---- ------
0    4358 2460
  • Works if i select individual measurements
> SELECT "input_1"  FROM power LIMIT 2
name: power
time                input_1
----                ------------------------------
1559178870000000000 3415
1559178870000000000 1795

> SELECT "input_2"  FROM power LIMIT 2
name: power
time                input_2
----                ---------------
1564456210000000000 1968
1564456210000000000 1334

Is there a way to get the results with out using last()?
I encountered this when I was attempting to sum the values in Grafana

2

Hey @uvazquez ,

One thing you have to consider is for that particular timestamp in query1 “1559178870000000000” there’s no value for input_2 and as you’re limiting it to 2, you are not able to see any values for input_2.

Either try removing limit or select a time range which has both the values…btw empty values means that there’s no data for input_2 at that particular timestamp