雅典娜日期差异 [英] Athena DateDiff

问题描述

我正在尝试做我认为是一个简单的日期差异函数，但由于某种原因，我的单位值被读取为一列(dd")，所以我不断收到一个列无法解析强>错误

I am trying to do what I think is a simple date diff function but for some reason, my unit value is being read as a column ("dd") so I keep getting a column cannot be resolved error

我正在使用 AWS Athena

I am using AWS Athena

我的代码是这个

SELECT "reservations"."id" "Booking_ID"
    , "reservations"."bookingid" "Booking_Code"
    , "reservations"."property"."id" "Property_id"
    , CAST("from_iso8601_timestamp"("reservations"."created") AS date) "Created"
    , CAST("from_iso8601_timestamp"("reservations"."arrival") AS date) "Arrival"
    , CAST("from_iso8601_timestamp"("reservations"."departure") AS date) "Departure"
    , CAST("from_iso8601_timestamp"("reservations"."modified") AS date) "Modified"
    , date_diff("dd", CAST("from_iso8601_timestamp"("reservations"."created") AS date), CAST("from_iso8601_timestamp"("reservations"."arrival") AS date)) "LoS"
FROM
    "database".reservations
LIMIT 5;

我试图从创建日期"和到达日期"获取天数差异

I am trying to get the difference in days from the "created date" and "Arrival Date"

我已经用 DD,"DD","dd",dd,Day,day,"day" 尝试过 date_diff 并且我得到了同样的错误.

I have tried date_diff with DD,"DD","dd",dd,Day,day,"day" and i get the same error.

推荐答案

Athena 基于 Presto.请参阅 Presto 文档以了解 date_diff() -- 单位是常规的 varchar，所以它需要放在单引号中:

Athena is based on Presto. See Presto documentation for date_diff() -- the unit is regular varchar, so it needs to go in single quotes:

date_diff('day', ts_from, ts_to)

这篇关于雅典娜日期差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！