[
https://issues.apache.org/jira/browse/HIVE-27553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ZhengBowen reassigned HIVE-27553:
---------------------------------
Assignee: ZhengBowen
> After upgrading from Hive1 to Hive3, Decimal computation experiences a loss
> of precision
> ----------------------------------------------------------------------------------------
>
> Key: HIVE-27553
> URL: https://issues.apache.org/jira/browse/HIVE-27553
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Affects Versions: 3.1.3
> Reporter: ZhengBowen
> Assignee: ZhengBowen
> Priority: Major
> Labels: pull-request-available
> Attachments: image-2023-07-31-20-40-00-679.png,
> image-2023-07-31-20-40-35-050.png, image-2023-07-31-20-43-05-379.png,
> image-2023-07-31-20-43-49-775.png, image-2023-08-30-14-53-06-442.png,
> image2022-5-11_10-55-54.png
>
>
> I can reproduce this bug.
> {quote}{{create}} {{table}} {{decimal_test(}}
> {{ }}{{id }}{{{}int{}}}{{{},{}}}
> {{ }}{{quantity }}{{{}decimal{}}}{{{}(38,8),{}}}
> {{ }}{{cost }}{{{}decimal{}}}{{{}(38,8){}}}
> {{) stored }}{{as}} {{textfile;}}
>
> {{insert}} {{into}} {{decimal_test }}{{{}values{}}}{{{}(1,0.00008000,
> 0.00015000);{}}}
>
> {{select}} {{quantity * cost }}{{from}} {{decimal_test;}}
> {quote}
> *1、The following are the execution results and execution plan on Hive-1.0.1：*
> !image-2023-07-31-20-40-00-679.png|width=550,height=230!
> !image-2023-07-31-20-43-05-379.png|width=540,height=144!
> *2、The following are the execution results and execution plan on Hive-3.1.3：*
> !image-2023-07-31-20-40-35-050.png|width=538,height=257!
> !image-2023-08-30-14-53-06-442.png|width=531,height=186!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
