ClickHouse实现类似Hive的row_number() over (partition by)的方法
摘要:
利用rowNumberInAllBlocks函数: hive写法: select orderid from (select orderid, row_number() over(partition by orderid order by datachange_lasttime desc) as ro 阅读全文
posted @ 2022-10-24 11:24 RICH-ATONE 阅读(914) 评论(0) 推荐(0) 编辑