[ZEPPELIN-5509] Zeppelin table display converting strings that appear like scientific notation to numeric

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.8.2
• Fix Version/s: 0.10.0
• Component/s: front-end, GUI, zeppelin-client, zeppelin-web

Environment

Amazon Elastic Map Reduce

Zeppelin 0.8.2

• Assignee: Unassigned
• Reporter: Robert Johnson
• Created: 03/Sep/21 14:47
• Updated: 03/Sep/21 15:13
• Resolved: 03/Sep/21 15:13

Description

Zeppelin table display is converting strings that appear to be scientific notation into a numeric. In this case, these are value codes, not numeric values. This is causing data to be displayed incorrectly. This also effects the data if exported from the result set.

 

%pyspark
data = [["Test1", "10E00"], ["Test2", "12E10"], ["Test3", "10E00000"], ["Test4", "10EAA"], ["Test5", "12E01"], ["Test6", "12E00"]]
columns = ["Name", "Value"]
df = spark.createDataFrame(data, columns)
df.show()
z.show(df)

+-----+--------+
| Name|   Value|
+-----+--------+
|Test1|   10E00|
|Test2|   10E10|
|Test3|10E00000|
|Test4|   10EAA|
|Test5|   12E01|
|Test6|   12E00|
+-----+--------+

Name	Value
Test1	10
Test2	10000000000
Test3	10
Test4	10EAA
Test5	120
Test6	12