[jira] [Created] (DRILL-7957) Unexpected query results when multiplying decimal column with constant (Parquet files)

["Martin Puge Nielsen (Jira)" <ji...@apache.org>]

Martin Puge Nielsen created DRILL-7957:
------------------------------------------

             Summary: 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
         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

 

N.B:

Removing the summarization from the script and simply do `Hours` * 0.75 returns correct decimal values but they cannot be summarized to 9.9375.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)