You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "pengfei.zhan (Jira)" <ji...@apache.org> on 2023/07/11 03:50:00 UTC
[jira] [Created] (CALCITE-5838) derive wrong decimal divide type
pengfei.zhan created CALCITE-5838:
-------------------------------------
Summary: derive wrong decimal divide type
Key: CALCITE-5838
URL: https://issues.apache.org/jira/browse/CALCITE-5838
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.34.0
Reporter: pengfei.zhan
Given a table metadata structure as follows:
{code:sql}
create table `tbl_test`(`CRR` decimal(38,2), `DT` varchar(4096)) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
{code}
If the following query is executed,
{code:sql}
select sum(CRR_0/1000000000.02) from (select sum(CRR) as CRR_0 from tbl_test where DT='20230705') T1
{code}
The RexCall CRR_0/1000000000.02 derived a decimal type of decimal(38, 0). I referred the derived type in spark, but it gives decimal(38, 4). It looks like the inferred type is more reasonable.
[hive doc | https://cwiki.apache.org/confluence/download/attachments/27362075/Hive_Decimal_Precision_Scale_Support.pdf]
[sql server doc | https://msdn.microsoft.com/en-us/library/ms190476.aspx]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)