[
https://issues.apache.org/jira/browse/DRILL-7957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Martin Puge Nielsen updated DRILL-7957:
---------------------------------------
Description:
I get unexpected results when trying to multiply a constant value with a
decimal(29,6) column.
See attached files for sample data and a test script.
The correct/desired output should be 13.25 * 0.75 = 9.9375
EDIT:
I noticed that SUM(`Hours` * 0.75) returns 9.9375 which is the expected result.
However, the other variations from TestScript.txt should logically all return
9.9375
was:
I get unexpected results when trying to multiply a constant value with a
decimal(29,6) column.
See attached files for sample data and a test script.
The correct/desired output should be 13.25 * 0.75 = 9.9375
EDIT:
I noticed that SUM(`Hours` * 0.75) returns 9.9375 which is the expected result.
However, the other variations should logically all return 9.9375
> Unexpected query results when multiplying decimal column with constant
> (Parquet files)
> ---------------------------------------------------------------------------------------
>
> Key: DRILL-7957
> URL: https://issues.apache.org/jira/browse/DRILL-7957
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill, Storage - Parquet
> Affects Versions: 1.19.0
> Reporter: Martin Puge Nielsen
> Priority: Major
> Attachments: TestFile.parquet, TestScript.txt
>
>
> I get unexpected results when trying to multiply a constant value with a
> decimal(29,6) column.
>
> See attached files for sample data and a test script.
>
> The correct/desired output should be 13.25 * 0.75 = 9.9375
> EDIT:
> I noticed that SUM(`Hours` * 0.75) returns 9.9375 which is the expected
> result. However, the other variations from TestScript.txt should logically
> all return 9.9375
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
