[
https://issues.apache.org/jira/browse/DRILL-7947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17361236#comment-17361236
]
ASF GitHub Bot commented on DRILL-7947:
---------------------------------------
cgivre merged pull request #2255:
URL: https://github.com/apache/drill/pull/2255
--
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)
