These are chat archives for influxdata/influxdb

13th
May 2017
Julien Syx
@Seraf
May 13 2017 19:36

Hello everyone,
I'm stuck with a query :

> SELECT * FROM "flowerpower_in_greenhouse"
name: flowerpower_in_greenhouse
-------------------------------
time            air_temp    battery    fertilizer    host        light    location    sensor    sensor_1        soil_moisture
1494700742000000000    0        100    0        serre-telegraf    0    serre            Flower_power_A4DA    22.1140003204346
1494700742000000000    0        92    0        serre-telegraf    0    serre            Flower_power_E945    14.5739994049072
1494700802000000000    0        100    0        serre-telegraf    0    serre            Flower_power_A4DA    22.1140003204346

Here are the series :

flowerpower_in_greenhouse,host=serre-telegraf,location=serre,sensor=Flower_power_A4DA
flowerpower_in_greenhouse,host=serre-telegraf,location=serre,sensor=Flower_power_E945

But > SELECT * FROM "flowerpower_in_greenhouse" WHERE "sensor" = 'Flower_power_E945' returns me nothing, any idea please ?

Also, here are the lines my exec input returns :
flowerpower,sensor=Flower_power_E945 light=0,soil_moisture=14.4289989471436,air_temp=0,fertilizer=0,battery=92
flowerpower,sensor=Flower_power_A4DA light=0,soil_moisture=22.1140003204346,air_temp=0,fertilizer=0,battery=100