SELECT DISTINCT ON is not supported

[jredd]

In one of my views I need to call distinct on my query but I'm receiving this when I hit the django end point

Exception Type: NotSupportedError
Exception Value:  SELECT DISTINCT ON is not supported

[arpitremarkable]

It is not supported by redshift itself, maybe you can use DISTINCT with a nested query to achieve what you want.

[emyller]

This doesn't seem to be an issue with django-redshift-backend and it's also not viable -- or even possible -- to interpret distinct on into distinct + subquery. 😞

[shimizukawa]

postgres backend on Django supports "SELECT DISTINCT ON" and other backends don't.

• https://github.com/django/django/blob/1.9/django/db/backends/base/operations.py#L130
• https://docs.djangoproject.com/en/dev/ref/models/querysets/#distinct

I couldn't find information that "DISTINCT ON" is not supported, but it seems that it doesn't actually support it. http://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-features.html

For this reason I will explicitly implement unsupported with django redshift backend.

[GnanaShekhar]

It is not supported by redshift itself, maybe you can use DISTINCT with a nested query to achieve what you want.

No its possible for multiple columns.

[jredd]

I could have sworn that distinct was possible...

https://docs.aws.amazon.com/redshift/latest/dg/r_DISTINCT_examples.html