Spark SQL - Convert String to Int (int and cast function)

visibility 1,750 event 2022-06-04 access_time 7 months ago language English
more_vert

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
copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts