Spark/Hive converting decimal to null value if we specify the precision
more than available precision in file. Below example give you details. I
am not sure why its converting into Null.
Note: You need to trim string before casting to decimal
Table data with col1 and col2 columns
val r =
Hi Experts
I am trying to convert a string with decimal value to decimal in Spark Sql
and load it into Hive/Sql Server.
In Hive instead of getting converted to decimal all my values are coming as
null.
In Sql Server instead of getting decimal values are coming without precision
Can you please
