4 ms·
This is how I do it. You can cross join the derived table to itself if you need more rows. Much more performant and naturally relational way of generating data
by vp8989 6y ago
This is how I do it. You can cross join the derived table to itself if you need more rows.
Much more performant and naturally relational way of generating data than looping recursively.
- kroolik 6y agoAlso one of the only ways to get sequences in joins in Redshift. Unfortunately, only Redshift master nodes support 'generate_series'. If your query contains join that are spread across multiple worker nodes, Redshift will report an error saying 'generate_series' no supported. Gotta select row number on some big enough table!