[HIVE-24628] Decimal values are displayed as scientific notation in beeline

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Beeline
• Labels: pull-request-available
• Assignee: Naresh P R
• Reporter: Naresh P R
• Created: 12/Jan/21 22:53
• Updated: 17/Nov/22 08:48
• Resolved: 14/Jan/21 17:27

Description

As we are using BigDecimal.toString() returns scientific notation instead of original text, which confuse customer. It should be changed to toPlainString() at here

https://github.com/apache/hive/blob/master/beeline/src/java/org/apache/hive/beeline/Rows.java#L165

Repro steps:

 

beeline> select cast(0 as decimal(20,10));
//output
0E-10 

 

Issue Links

• links to: GitHub Pull Request #1861
• links to: GitHub Pull Request #1861