Use distinct(*) with count function

1

Due to InfluxDB doc, we can use “distinct” function in nested syntax as follow:
SELECT COUNT(DISTINCT( [ * | <field_key> | /<regular_expression>/ ] )) […]
but when I perform this query:
SELECT COUNT(DISTINCT(*)) From <my_measurement>
I got error:
ERR: expected field argument in distinct()

2

Did you put the measurement name in double-quotes? Could you show us the query you ran?

3

Hello
I got the same error ERR: expected field argument in count()

Here’s my query :

SELECT COUNT(DISCTINCT(*)) FROM “container_tasks_state” where “state” = ‘running’

any help?
Thanks in advance
Kind regards