joanne7906的专栏

原创 row_number() over (partition by idno order by id desc)

row_number() over (partition by idno order by id desc) 在获取分区信息的时候，row_number比group by 好用多了。因为row_number可以返回分区多少行以内的整行信息。 eg: %hive drop table if exists yll_tmp.loan_consumer_application_idno_m