Window Agg FIRST : Spark n BQ results don't match with window frame.

Description

Attaching the Pipeline JSOn

when using the function FIRST.
1. with Frame type : Row and Preceding : 0 , Following : 0, IT PASSES and results match .

2. But with Frame type : Row and Preceding : -1 , Following : 1, IT PASSES for both Spark n BQ ,
but the Results differ.


Release Notes

None

Attachments

1

Activity

Show:

Sanket Sahu April 3, 2023 at 12:47 PM

This is fixed by

Verified the same by matching results of SPARk and BQ.

Unresolved
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Fix versions

Affects versions

Priority

More fields

Created March 31, 2023 at 10:00 AM
Updated April 3, 2023 at 12:47 PM