Influxdb query on tag returns nothing

Question

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 *.

question from:https://stackoverflow.com/questions/66045370/influxdb-query-on-tag-returns-nothing

Answer 1

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"