hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chaoyu Tang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-14281) Issue in decimal multiplication
Date Tue, 19 Jul 2016 15:43:20 GMT
Chaoyu Tang created HIVE-14281:
----------------------------------

             Summary: Issue in decimal multiplication
                 Key: HIVE-14281
                 URL: https://issues.apache.org/jira/browse/HIVE-14281
             Project: Hive
          Issue Type: Bug
          Components: Types
            Reporter: Chaoyu Tang
            Assignee: Chaoyu Tang


{code}
CREATE TABLE test (a DECIMAL(38,18), b DECIMAL(38,18));
INSERT OVERWRITE TABLE test VALUES (20, 20);
SELECT a*b from test
{code}
The returned result is NULL (instead of 400)
It is because Hive adds the scales from operands and the type for a*b is set to decimal (38,
36). Hive could not handle this case properly (e.g. by rounding)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message