我正在尝试创建以下视图:
CREATE OR REPLACE VIEW view_events AS
(
SELECT
"rank"() OVER (PARTITION BY "tb1"."innerid" ORDER BY "tb1"."date" ASC) "r"
, "tb2"."opcode"
, "tb1"."innerid"
, "tb1"."date"
, From_iso8601_timestamp(tb1.date) as "real_date"
, "tb2"."eventtype"
, "tb1"."fuelused"
, "tb1"."mileage"
, "tb1"."latitude"
, "tb1"."longitude"
FROM
rt_message_header tb1
, rt_messages tb2
WHERE ((("tb1"."uuid" = "tb2"."header_uuid") AND ("tb2"."opcode" = '39')) AND ("tb2"."type" = 'event'))
ORDER BY "tb1"."innerid" ASC, "tb1"."date" ASC
)
它给出了以下错误:
您的查询有以下错误:不支持的配置单元类型:带有时区的时间戳
但是,当我自己运行查询时,它工作得很好,并且From_iso8601_timestamp被提到为有效的日期函数here。
有人能告诉我我哪里做错了吗?
https://stackoverflow.com/questions/50832977
复制相似问题