SPRKSCL1129

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

Description

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

Input code

val result = floor("columnName")

Output code

/*EWI: SPRKSCL1129 => org.apache.spark.sql.functions.floor has a workaround, see documentation for more info*/
val result = floor("columnName")

Scenarios

This function has three overloads.

1. floor(e: Column)

Action: does not need any change.

2. floor(e: Column, scale: Column)

Action: does not need any change, becuse is not supported by Snowpark.

3. floor(columnName: String)

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

val result = floor(col("columnName"))

Recommendation

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