Apache Tajo - row_number()
Advertisements
Let us now check the row_number() function with the following query.
Query
sampledb> select *,row_number() over (order by name) as rowno from mytable;
Result
The above query will generate the following result.
The query assigns the row number for each row in the table.
apache_tajo_aggregate_and_window_functions.htm
Advertisements