-
Notifications
You must be signed in to change notification settings - Fork 3.5k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
DISTINCT(*) and DISTINCT(*regex*) returning error #9973
Comments
You can only have one
So you have to specify a field for |
Sure, please, update documentation and official examples since it states opposite to what you say. |
@jsternberg I am quite sure it used to work like stated in the documentation, now my (fairly old) CQs return errors |
So, does anyone now how to filter out "duplicate" rows / only get "unique" rows (ignoring the timestamp)? Following the InfluxDB docs, I was hoping that a |
i am trying this SELECT DISTINCT(*) From db but getting error (experted filed argument in distinct) |
Hi!
InfluxDB documentation says that I can use
DISTINCT(*)
in my queries without specifying fields explicitly.On executing query from the documentation
SELECT DISTINCT(*) FROM "h2o_feet"
Expected behavior: list of distinct values for
distinct_level_description
,distinct_water_level
Actual behavior: InfluxDB returns the following error:
ERR: expected field argument in distinct()
The same error if I try to put regex inside
DISTINCT
.Was this feature removed? Please, update documentation then.
InfluxDB version 1.5.1
The text was updated successfully, but these errors were encountered: