influxdata / influxdata/influxdb

Allow DISTINCT function to operate on tags

Open
#3,880 80 comments 76 reactions 1 assignee Claimed by @e-dard View on GitHub
1.x area/queries flux/triaged in progress kind/feature-request
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

I would like to have following feature:

Since the new release 0.9.3 tags are resulting as own columns if you use SELECT \* FROM measurement

Currently, it's not possible to use commands on this columns. An example:

```
SELECT * FROM measurements
```

returns:

```
time tagA tagB value
xxx M N 0.3
xxx M O 0.4
xxx P R 0.2
```

I want to do a query like:

```
SELECT count(distinct(tagA)) FROM measurements
```

The result is

```
2 (M+P)
```

Anyone else need this feature?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.