Why can't I use the FIRST and LAST SQL commands in SQL Processor?

Lenses SQL
1

I often use SQL FIRST and LAST command in SQL Studio, but I can’t use them in SQL Processor?

Why not??

2

One of the key differences between SQL Snapshot and SQL Processors is the state of the data it interacts with.

SQL Snapshot is backwards looking at existing finite data already in the topic, SQL Processor is forward looking at theoretically infinite data currently streaming into topics.

Because SQL Processors work with “infinite” / “endless” data some commands will not work - in particular things like “FIRST” and “LAST” make no sense in an infinite world of incoming streaming data.

3

Thanks Drew now that I look at it this way it makes total sense.