Search code examples
influxdb

Influxdb query on tag returns nothing

I have an Influxdb with lots of fields and a single tag:

> show tag keys
name: rtl433
tagKey
------
model

Now, I want a list of all possible values for model, so I run

SELECT model FROM rtl433
>

-and it returns nothing. Why? There's lots of data in model if I select *.

Solution

  • You are trying to use classic SQL solution, but InfluxDB is not classic SQL DB. You should check InfluxDB doc and you will find solution:

    SHOW TAG VALUES WITH KEY = "model"