https://community.cloudera.com/t5/Support-Questions/Convert-String-to-Int/m-p/334271#M231693 <P>How to convert String Into Int in the SQL table</P> Thu, 20 Jan 2022 10:14:15 GMT KanteTelecom 2022-01-20T10:14:15Z https://community.cloudera.com/t5/Support-Questions/Convert-String-to-Int/m-p/334271#M231693 <P>How to convert String Into Int in the SQL table</P> Thu, 20 Jan 2022 10:14:15 GMT https://community.cloudera.com/t5/Support-Questions/Convert-String-to-Int/m-p/334271#M231693 KanteTelecom 2022-01-20T10:14:15Z https://community.cloudera.com/t5/Support-Questions/Convert-String-to-Int/m-p/334341#M231727 <P><SPAN>&nbsp;With the help of cast udf function, you can convert a string to an integer.<BR /><BR />cast(str_column as int)<BR /></SPAN><BR />Reference -&nbsp;<A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-TypeConversionFunctions" target="_blank">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-TypeConversionFunctions</A><BR /><BR /><SPAN>If the value is between –2147483648 and 2147483647, cast(string_filed as int) will work.</SPAN><BR /><BR /></P><LI-CODE lang="markup">0: jdbc:hive2:Hive&gt; select cast('2147483647' as int); INFO : Compiling command(queryId=hive_20220121054634_f3485a1b-692a-412d-8fe4-1c616c21d0aa): select cast('2147483647' as int) INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:_c0, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=hive_20220121054634_f3485a1b-692a-412d-8fe4-1c616c21d0aa); Time taken: 0.17 seconds INFO : Executing command(queryId=hive_20220121054634_f3485a1b-692a-412d-8fe4-1c616c21d0aa): select cast('2147483647' as int) INFO : Completed executing command(queryId=hive_20220121054634_f3485a1b-692a-412d-8fe4-1c616c21d0aa); Time taken: 0.009 seconds INFO : OK +-------------+ | _c0 | +-------------+ | 2147483647 | +-------------+ 1 row selected (0.296 seconds) 0: jdbc:hive2://hive&gt; select cast('2147483648' as int); INFO : Compiling command(queryId=hive_20220121054651_15cbd283-7de5-4310-bbe9-b262ebbd1e07): select cast('2147483648' as int) INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:_c0, type:int, comment:null)], properties:null) INFO : Completed compiling command(queryId=hive_20220121054651_15cbd283-7de5-4310-bbe9-b262ebbd1e07); Time taken: 0.059 seconds INFO : Executing command(queryId=hive_20220121054651_15cbd283-7de5-4310-bbe9-b262ebbd1e07): select cast('2147483648' as int) INFO : Completed executing command(queryId=hive_20220121054651_15cbd283-7de5-4310-bbe9-b262ebbd1e07); Time taken: 0.006 seconds INFO : OK +-------+ | _c0 | +-------+ | NULL | +-------+ 1 row selected (0.086 seconds)</LI-CODE><P>&nbsp;</P> Fri, 21 Jan 2022 05:57:18 GMT https://community.cloudera.com/t5/Support-Questions/Convert-String-to-Int/m-p/334341#M231727 ggangadharan 2022-01-21T05:57:18Z