You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Laurent Goujon (Jira)" <ji...@apache.org> on 2021/06/04 19:56:00 UTC
[jira] [Commented] (DRILL-7948) Unable to query file with required
fixed_len_byte_array decimal columns
[ https://issues.apache.org/jira/browse/DRILL-7948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17357592#comment-17357592 ]
Laurent Goujon commented on DRILL-7948:
---------------------------------------
I just verified that 1.18.0 release has the same issue
> Unable to query file with required fixed_len_byte_array decimal columns
> -----------------------------------------------------------------------
>
> Key: DRILL-7948
> URL: https://issues.apache.org/jira/browse/DRILL-7948
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Parquet
> Affects Versions: 1.19.0, 1.18.0
> Environment: Docker: master
> Sys.Version:
> |1.19.0-SNAPSHOT|82c03e44eac3863a10e599d8f2068fc58e986041|
>
> Reporter: Nick Stenroos-Dam
> Priority: Blocker
> Attachments: sqlline.log
>
>
> When attempting to query a file with required fixed_len_byte_array decimal columns, the exception: *INTERNAL_ERROR ERROR: Error in drill parquet reader* is thrown
> Full Exception:
>
> {noformat}
> {{org.apache.drill.common.exceptions.UserRemoteException: INTERNAL_ERROR ERROR: Error in drill parquet reader (complex). Message: Failure in setting up reader Parquet Metadata: ParquetMetaData{FileMetaData{schema: message schema
> { required fixed_len_byte_array(16) Sale (DECIMAL(29,6)); required fixed_len_byte_array(16) Cost (DECIMAL(29,6)); }
> , metadata: {}}, blocks: [BlockMetaData{1, 260 [ColumnMetaData
> {SNAPPY [Sale] required fixed_len_byte_array(16) Sale (DECIMAL(29,6)) [RLE, PLAIN, PLAIN_DICTIONARY], 36}
> , ColumnMetaData
> {SNAPPY [Cost] required fixed_len_byte_array(16) Cost (DECIMAL(29,6)) [RLE, PLAIN, PLAIN_DICTIONARY], 292}
> ]}]} Fragment: 0:0 Please, refer to logs for more information. [Error Id: 772dfd77-1eaf-4cbc-9b7b-4d4a1e5c3080 on 67732da24351:31010]}}
> {noformat}
>
> Test Query:
> {code:sql}
> select * from data.`SingleRow_RequiredFixedLength_Decimal.parquet`{code}
> Test File:
> [https://projectbiaps-my.sharepoint.com/:u:/g/personal/nisd_project_bi/ET-9G1pyXmJGm6AaLv9BTMsBBInk-EuvFRWEeA-gAqXDwQ?e=wkAH7H]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)