- Hive
datediff('2009-03-01', '2009-02-27')は2 - PrestoだとStringな日付での比較はできないから
date_diff('day', CAST('2009-03-01' AS Date), CAST('2009-02-27' AS Date))っていうふうにTimestampかDateにキャストして、結果は-2
LanguageManual UDF - Apache Hive - Apache Software Foundation
datediff('2009-03-01', '2009-02-27') は2date_diff('day', CAST('2009-03-01' AS Date), CAST('2009-02-27' AS Date)) っていうふうにTimestampかDateにキャストして、結果は-2LanguageManual UDF - Apache Hive - Apache Software Foundation