2 Risposte
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
0
Redshift does not support the function generate_series().
https://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-functions.html
con risposta 6 anni fa
0
As @toebs2 says, this function is not supported. You can often use the ROW_NUMBER() function over an internal table to generate a series of data points instead.
WITH generated_dates
AS (SELECT DATEADD('month', -n, DATE_TRUNC('month', CURRENT_DATE)) AS generated_date
FROM (SELECT ROW_NUMBER() OVER () AS n FROM stl_scan LIMIT 3) n
ORDER BY generated_date DESC
)
SELECT u.name AS metric
,generated_dates.generated_date AS TIME
FROM generated_dates
INNER JOIN temp_users AS u ON date_trunc('mon', u.created_at) = generated_dates.generated_date
;
con risposta 6 anni fa
Contenuto pertinente
- AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata un anno fa