Select tag and value from measurment

InfluxDB 2 Dashboards
1

Hi every body,

i am a newbie in influxql, i’ll try to select tag between select and from clause but it doesnt work.
only fields are available.
How i can write my request like :
select time, code, response from httplog where time> "..."
code is a key and not a field :
httplog,code=200,application=AAAA response=1200,size=3892 14845353453

the result is empty, select * works but i don’t want any fields

Best regards,

2

I believe this would work: select "response","code" from httplog

See documentation on the select statement for field key and tag key.

1 Like
3

yes, it’s work. i think i need choose a value with tag otherwise it doesn’’ work

Thanks a lot

1 Like
4

Yep, as the docs say:

Be careful with your use of the terms tag and field. Things will be easier if you’re explicit every time.

1 Like