Kontext Kontext / Code Snippets & Tips

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

event 2022-06-04 visibility 7,723 comment 0 insights toc
more_vert
insights Stats
toc Table of contents

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
More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts