Spark SQL - Convert String to Int (int and cast function)
articleArticles 73
imageDiagrams 20
codeCode 45
chat_bubble_outlineThreads 1
commentComments 3
loyaltyKontext Points 1063
account_circle Profile
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)
2022Use 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.
Log in with external accounts
warning Please login first to view stats information.
