Apache Tajo - LAST_VALUE(expression)



Let us now check last_value(exp) function with the following query.

Query

sampledb> select last_value(mark) as lastvalue from mytable;  

Result

The above query will generate the following result.

lastvalue 
------------------------------- 
95 

The query returns the last value of mark column from mytable.

apache_tajo_aggregate_and_window_functions.htm
Advertisements