In Spark SQL, we can use int
and cast
function to covert string to integer.
Use int function
The following code snippet converts string to integer using int
function.
spark-sql> SELECT int('2022');
CAST(2022 AS INT)
2022
Use cast function
The following example utilizes cast
function.
spark-sql> SELECT cast('2022' as int);
CAST(2022 AS INT)
2022