Apache Tajo - rank()
Advertisements
Let us now check the rank() function with the following query.
Query
select rank() over (order by name) as rank from mytable;
Result
The above query will generate the following result.
rank ------------------------------- 1 2 3 4 5 6 7 8 9 10
The query returns the rank of the current row which is order by name.
apache_tajo_aggregate_and_window_functions.htm
Advertisements