hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "j.barrett Strausser" <j.barrett.straus...@gmail.com>
Subject Semantics of Rank.
Date Wed, 24 Jul 2013 18:59:50 GMT
It seems as though I am required to pass in an argument to RANK().

What is the effect of passing this argument in ?

In a RANK function the output for RANK should be the number of rows
preceding
a row in a given window. As  windows are specified by the partition and
order by fields I don't understand the effect of passing in an arg to RANK

Are the other non-aggregate function similar? Meaning : Cume_dist, Ntile
-- 


https://github.com/bearrito
@deepbearrito

Mime
View raw message