Cannot get list of unique tag values from influxdb

1

I am new to influxdb but this is just weird. I have a new DB, started up a telegraf client pushing some data, and I know the data is there. I need to get a unique list of host names, but everything I could find online fails to work. Look:

> SHOW TAG VALUES WITH key =~ /.*/
name: cpu
key  value
---  -----
cpu  cpu-total
cpu  cpu0
cpu  cpu1
cpu  cpu2
host fw.xxx.local

name: disk
key    value
---    -----
device devfs
device md0
fstype zfs
host fw.xxx.local
mode   rw
path   /
path   /dev

name: diskio
key  value
---  -----
host fw.xxx.local
name ada0

name: mem
key  value
---  -----
host fw.xxx.local

name: net
key       value
---       -----
host fw.xxx.local
interface em0

name: processes
key  value
---  -----
host fw.xxx.local

name: swap
key  value
---  -----
host fw.xxx.local

name: system
key  value
---  -----
host fw.xxx.local

So why, when I do

> SHOW TAG VALUES WITH key = host
>

do I get no data?

I expected to see:

fw.xxx.local
2

I was using:

Connected to http://localhost:8086 version 1.6.4

I upgraded using the custom repository to:

Connected to http://localhost:8086 version 1.7.8

And now:

> SHOW TAG VALUES WITH KEY = "host"
name: cpu
key  value
---  -----
host fw.xxx.local

name: disk
key  value
---  -----
host fw.xxx.local

name: diskio
key  value
---  -----
host fw.xxx.local

So the latest version in Ubuntu 19.04 is broken?

3

Hi @pwnell ,

the latest version ( 1.7.8 ) seems ok , or do I misunderstand ,

best regards ,

4

So far yes, for that same query it returned the data I wanted.