Apache Tajo - LAST_VALUE(expression)


Advertisements


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