SPRKSCL1115

org.apache.spark.sql.functions.round has a workaround.

Description

This issue appears when the tool detects the usage of org.apache.spark.sql.functions.round which has a workaround.

Input code

val result = round(someColumn, 5)

Output code

/*EWI: SPRKSCL1115 => org.apache.spark.sql.functions.round has a workaround, see documentation for more info*/
val result = round(someColumn, 5)

Scenarios

This function has two overloads.

1. round(e: Column)

Action: does not need any change.

2. round(e: Column, scala: Int)

Action: convert the second param to Column type using the com.snowflake.snowpark.functions.col function. For example:

val result = round(someColumn, col(5))

Recommendation

  • For more support, you can email us at snowconvert-info@snowflake.com. If you have a contract for support with Snowflake, reach out to your sales engineer and they can direct your support needs.

#332: [SIT-1562] SQL Readiness

Change request updated