Cast string to decimal

[_Raju]

Hello, can anyone help me with the below error.

I'm trying to cast the string column into decimal. When I try to do that I'm getting the "Py4JJavaError: An error occurred while calling t.addCustomDisplayData. : java.sql.SQLException: Status of query associated with resultSet is FAILED_WITH_ERROR. Numeric value 'WVL383' is not recognized Results not generated." error.

The dataframe and error details are attached.

[_Raju]

Hi Kaniz,

Thank you for your response.

I',m expecting that the new column should be populated as NULL after the decimal conversion, if it has any characters as below example. But it is not happening when I use the same casting in my original file.