[
https://issues.apache.org/jira/browse/DRILL-7948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nick Stenroos-Dam updated DRILL-7948:
-------------------------------------
Description:
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]
was:
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:
{{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]}}
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
> 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
> 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)
