I believe container_id is a field. As such, SHOW TAG VALUES will never display that column. SHOW TAG VALUES shows only the distinct tag values assigned to a given tag key. If you want field data, you must use a SELECT statement.
Please review the https://docs.influxdata.com/influxdb/v0.13/query_language/data_exploration/ and https://docs.influxdata.com/influxdb/v0.13/query_language/schema_exploration/ docs to understand how SELECT and SHOW queries function. On Wed, Jun 15, 2016 at 12:46 PM, Quick Query <[email protected]> wrote: > Please let me know if this is possible using InfluxDB ? > > Cheers! > > > On Wednesday, June 15, 2016 at 10:27:30 AM UTC-7, Quick Query wrote: >> >> Hi Everyone, >> >> I can get the docker container ID list using the following query: >> SELECT container_id from docker_container_net where host='<HOSTNAME>' >> >> timecontainer_id >> 2016-06-15T17:14:41Z "<container-id>" >> >> >> But, can I do this using a "SHOW TAG VALUES WITH KEY ..." query instead? >> >> Appreciate any pointers/help. >> >> Cheers! >> >> -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/3e71dc01-f769-42cb-b12e-a1ec14f91c45%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/3e71dc01-f769-42cb-b12e-a1ec14f91c45%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvO-JKqAEdv4gQ%2BpZMRHHCsMa3DOOL%2Bbs%3DKV8vpDStkGEA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
