我正在尝试运行以下命令:
DROP TABLE IF exists timestamp_15min;
Create TEMP TABLE timestamp_15min AS
SELECT
dateadd(minute,min_15,dateadd(hour,hours,dateadd(day,days,start_date::timestamp))) AS date_time,
TO_CHAR(date_time,'HH24') || ':' || TO_CHAR(date_time,'MI') || ':' || '00' AS mins15
FROM
(SELECT trunc(sysdate-14) AS start_date)
CROSS JOIN (SELECT generate_series(0,14,1) AS days)
CROSS JOIN (SELECT generate_series(0,24,1) AS hours)
CROSS JOIN (SELECT generate_series(0,60,15) as min_15)
;
我得到这个错误
Specified types or functions (one per INFO message) not supported on Redshift tables.
如果我删除了DROP
AND CREATE TABLE
,并且只运行以下命令SELECT
就可以了
SELECT
dateadd(minute,min_15,dateadd(hour,hours,dateadd(day,days,start_date::timestamp))) AS date_time,
TO_CHAR(date_time,'HH24') || ':' || TO_CHAR(date_time,'MI') || ':' || '00' AS mins15
FROM
(SELECT trunc(sysdate-14) AS start_date)
CROSS JOIN (SELECT generate_series(0,14,1) AS days)
CROSS JOIN (SELECT generate_series(0,24,1) AS hours)
CROSS JOIN (SELECT generate_series(0,60,15) as min_15)
有人可以解释Redshift阻止功能或类型吗?
generate_series
引用Redshift用户表的查询中不支持。仅在查询目录表时它将起作用。
您可以使用该ROW_NUMBER()
函数生成序列。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句