Hive:窗函数和UDF整理

JerryXia 发表于 , 阅读 (37)
T CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END When a = true, returns b; when c = true, returns d; else returns e. 把计算结果赋值给end,并重命名为date_time case when a = -1 then 0 else 1 end as date_time

窗函数

Analytics functions