随笔分类 -  HIVE笔记

HIVE ROW_NUMBER()函数去重
摘要：SELECT * FROM( SELECT *,ROW_NUMBER() OVER(PARTITION BY a.claimno ORDER BY b.financiancedate DESC) number FROM (SELECT * FROM database1.table1 WHERE dt 阅读全文
posted @ 2020-02-11 14:40 wuyiping 阅读(1102) 评论(0) 推荐(0)