Links

MSCEWI1072

Window frame unit was changed to Rows

Severity

Low

Description

This warning is added when an unsupported Window Frame Unit was changed into Rows, leading to output differences. One example of this is the GROUPS unit, which is not supported by Snowflake.
Please note that this message is also used in cases where a Window Frame Unit is partially unsupported leading to it being changed, like the RANGE unit.

Example Code

Oracle:

SELECT
SUM(C_BIRTH_DAY)
OVER (ORDER BY C_BIRTH_COUNTRY
RANGE BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) AS MAX1
FROM WINDOW_TABLE;

Snowflake:

SELECT
SUM(C_BIRTH_DAY)
OVER (ORDER BY C_BIRTH_COUNTRY
ROWS /*** MSC-WARNING - MSCEWI1072 - WINDOW FRAME UNIT 'RANGE' WAS CHANGED TO ROWS ***/ BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) AS MAX1
FROM PUBLIC.WINDOW_TABLE;

Recommendations

  • Ensure deterministic ordering for rows to ensure deterministic outputs when running in Snowflake.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.