Do we have Analytical Window function in SAM by any chance? I tried to use Analytical Window functions in structured streaming but no luck. SO wondering if i solve this using SAM? I looked into it we can do stream-stream join which is what iam looking for. However not sure if we have window RANK/LAG functionality in SAM?
We can write custom functions that can be implemented in the window using which rank can be calculated. There is no native processor as such.