[
https://issues.apache.org/jira/browse/DRILL-7947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17358874#comment-17358874
]
ASF GitHub Bot commented on DRILL-7947:
---------------------------------------
vvysotskyi opened a new pull request #2255:
URL: https://github.com/apache/drill/pull/2255
# [DRILL-7947](https://issues.apache.org/jira/browse/DRILL-7947): Unable to
aggregate or filter nullable decimals in large record sets
## Description
Enforced returning `BigInteger.ZERO` for the case when empty byte array is
used to create `BigInteger`.
## Documentation
NA
## Testing
Checked manually.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> 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)
