[jira] [Created] (DRILL-7947) Unable to aggregate or filter nullable decimals in large record sets

["Nick Stenroos-Dam (Jira)" <ji...@apache.org>]

Nick Stenroos-Dam created DRILL-7947:
----------------------------------------

             Summary: Unable to aggregate or filter nullable decimals in large record sets
                 Key: DRILL-7947
                 URL: https://issues.apache.org/jira/browse/DRILL-7947
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Parquet
    Affects Versions: 1.19.0
         Environment: Docker: master

Sys.Version: 
|1.19.0-SNAPSHOT|82c03e44eac3863a10e599d8f2068fc58e986041|
            Reporter: Nick Stenroos-Dam


When attempting to aggregate or filter an optional decimal column, that have null values stored in Parquet, the exception: "*NumberFormatException: Zero length BigInteger*" is thrown.

It only seems to happen on large record sets, and not small record sets.

Test Query:
{code:sql}
select
 sum(cost), 
 avg(cost), 
 max(cost), 
 min(cost), 
 sum(sum(cost)) over () 
from data.`ManyRows_OptionalFixedLength_Decimal.parquet`
where cost > 0
{code}
Test File:
[https://projectbiaps-my.sharepoint.com/:u:/g/personal/nisd_project_bi/EaoM317e421OsnvxHn_S9ecBBffDx1LCt3xn93nJ06f0LQ?e=pVI0Of|https://projectbiaps-my.sharepoint.com/:u:/g/personal/nisd_project_bi/EaoM317e421OsnvxHn_S9ecBBffDx1LCt3xn93nJ06f0LQ?e=pVI0Of]



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