Use distinct(*) with count function

influxdb

#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?