Skip to content
Advertisement

RedShift Error when using COUNT (Distinct XXX) ERROR: XX000: This type of correlated subquery pattern is not supported due to internal error

I have a small query running in RedShift through Aginity that is getting the following error:

ERROR: XX000: This type of correlated subquery pattern is not supported due to internal error

Current Query:

However if i remove the DISTINCT it runs:

Advertisement

Answer

Does it work if you use window functions in a subquery?

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement