Apache Tajo - Apache Tajo Aggregate and Window Functions - Apache Tajo lag(value, offset, default) - Apache Tajo

How lag(value, offest, default)function works in Apache Tajo?

The lag(value, offest, default) function is checked with the following query:

Query

Result

The output generated by the above query is as follows -

The query returns the value evaluated at the row that is offset rows before the current row within the partition. Whenever the rows are not matching, then the given default value 2 is replaced.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Apache Tajo Topics