Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 5 Dec 2016 19:26:58 +0000 (UTC)
From: "Jason Dere (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13024866.1480619339000.441381.1480966018592@Atlassian.JIRA>
In-Reply-To: <JIRA.13024866.1480619339000@Atlassian.JIRA>
References: <JIRA.13024866.1480619339000@Atlassian.JIRA> <JIRA.13024866.1480619339077@arcas>
Subject: [jira] [Updated] (HIVE-15331) Decimal multiplication with high
 precision/scale often returns NULL
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Mon, 05 Dec 2016 19:27:00 -0000


     [ https://issues.apache.org/jira/browse/HIVE-15331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jason Dere updated HIVE-15331:
------------------------------
    Attachment: HIVE-15331.1.patch

Initial patch. Let's see what changes in the golden files.

> Decimal multiplication with high precision/scale often returns NULL
> -------------------------------------------------------------------
>
>                 Key: HIVE-15331
>                 URL: https://issues.apache.org/jira/browse/HIVE-15331
>             Project: Hive
>          Issue Type: Bug
>          Components: Types
>            Reporter: Jason Dere
>            Assignee: Jason Dere
>         Attachments: HIVE-15331.1.patch
>
>
> {noformat}
> create temporary table dec (a decimal(38,18));
> insert into dec values(100.0);
> hive> select a*a from dec;
> OK
> NULL
> Time taken: 0.165 seconds, Fetched: 1 row(s)
> {noformat}
> Looks like the reason is because the result of decimal(38,18) * decimal(38,18) only has 2 digits of precision for integers:
> {noformat}
> hive> set hive.explain.user=false;
> hive> explain select a*a from dec;
> OK
> STAGE DEPENDENCIES:
>   Stage-0 is a root stage
> STAGE PLANS:
>   Stage: Stage-0
>     Fetch Operator
>       limit: -1
>       Processor Tree:
>         TableScan
>           alias: dec
>           Select Operator
>             expressions: (a * a) (type: decimal(38,36))
>             outputColumnNames: _col0
>             ListSink
> Time taken: 0.039 seconds, Fetched: 15 row(s)
> {noformat}


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