Chaoyu Tang created HIVE-14347: ---------------------------------- Summary: Inconsistent hehavior in decimal multiplication Key: HIVE-14347 URL: https://issues.apache.org/jira/browse/HIVE-14347 Project: Hive Issue Type: Bug Components: Types Reporter: Chaoyu Tang Assignee: Chaoyu Tang
1. select cast('20' as decimal(38,18)) * cast('10' as decimal(38,18)) from test; returns 200, but the type of multiplication result is decimal (38,36) as shown in the query plan. 2. select a*b from atable where column a and b with both column type of decimal (38,18) and column value 20 and 10 respectively, we get result NULL but type decimal (38, 36). -- If we strictly follow current precision/scale manipulations for the decimal multiplication in Hive, the result in case1 400 has already exceeded the data range that decimal (38, 36) supports and it should return null. Current Hive deduces the precision/scale from constant values (10 and 20) and use them (2, 0) instead of the specified precision/scale (38, 18) in the multiplication. -- This message was sent by Atlassian JIRA (v6.3.4#6332)