SPRKPY1025

pyspark.sql.functions.ntile has a workaround

Category

Warning.

Description

This issue appears when the tool detects the usage of pyspark.sql.functions.ntile which has a workaround.

Input code:

col = ntile(number)

Output code:

#EWI: SPRKPY1025 => pyspark.sql.functions.ntile has a workaround, see documentation for more info
col = ntile(number)

Recommendation

• The parameter "n: int" should be converted to a column using lit. Example: ntile(n) => ntile(lit(n)).

• For more support, you can email us at [e-mail]. If you have a contract for support with Snowflake, reach out to your sales engineer and they can direct your support needs.