by shigemk2



presto case when

6.3. Conditional Expressions — Presto 0.221 Documentation The result for the matching value is returned. If no match is found, the result from the ELSE clause is returned if it exists, otherwise null is returned. else書いてないときにelseに…

hive datediff

日付Aと日付Bとの差分を取る関数。日付のフォーマットが違っててもいける。 LanguageManual UDF - Apache Hive - Apache Software Foundation