[HIVE-25968] cast(double as bigint) may cause an error return

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.1.1
• Fix Version/s: 2.3.0
• Assignee: xuping
• Reporter: xuping
• Created: 22/Feb/22 07:24
• Updated: 24/Feb/22 03:53
• Resolved: 24/Feb/22 03:49

Description

hello, everyone. when running sql using cast function in hive CLI, I got an unexpected return as the following pic described. And I am not sure if the function cast designed just as type conversion in java. In other words, I should handle double arithmetic precision on myself.

your reply sincerely.

Issue Links

• is fixed by: HIVE-13945 Decimal value is displayed as rounded when selecting where clause with that decimal value.