Spark SQL change format of the number

user_1251549 0
Viewed 41337

After show command spark prints the following:

+-----------------------+---------------------------+
|NameColumn             |NumberColumn               |
+-----------------------+---------------------------+
|name                   |4.3E-5                     |
+-----------------------+---------------------------+

Is there a way to change NumberColumn format to something like 0.000043?

apache-spark-sql apache-spark scala
3 Answers

In newer versions of pyspark you can use round() or bround() functions. Theses functions return a numeric column and solve the problem with ",".

it would be like:

df.withColumn("NumberColumn", bround("NumberColumn",5))
user_84012370
Related