I find so many reasons to hate Redshift that I’m going to start a series of notice.

ERROR: Limit clause is not supported:

(link)

In short, if you use UNLOAD() you can’t limit your queries. This is such a basic functionality miss. Sometimes I don’t care about your Massive Parallel Processing if you miss such basic freaking SQL functionality.

Ugh!