[
https://issues.apache.org/jira/browse/DRILL-7947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vova Vysotskyi reassigned DRILL-7947:
-------------------------------------
Assignee: Vova Vysotskyi
> 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
> Assignee: Vova Vysotskyi
> Priority: Blocker
> Attachments: sqlline.log
>
>
> 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)
