Spark: Decimal Column are shown in scientific notation instead of numbers

 

This issue relates to - When dataframe decimal type column having scale higher than 6, 0 values are shown in scientific notation SPARK-25177 

Solution - 

One can use format_number UDF to convert scientific notation into String, as shown below -