hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Chu <e...@rocketfuel.com>
Subject difference between partition by and distribute by in rank()
Date Fri, 11 Jul 2014 08:08:18 GMT
Does anyone know what

*rank() over(distribute by p_mfgr sort by p_name) *

does exactly and how it's different from

*rank() over(partition by p_mfgr order by p_name)*?

Thanks,

Eric

Mime
View raw message