[
https://issues.apache.org/jira/browse/DRILL-7399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17163538#comment-17163538
]
Dave Challis edited comment on DRILL-7399 at 7/23/20, 1:10 PM:
---------------------------------------------------------------
Also experiencing this issue in 1.17.0.
I've been unable to find any documentation about *store.parquet.use_new_reader*
though, so am reluctant to switch to using it without knowing about any
implications.
In the options section of Drill, the documentation for it also reads "*Not
supported in this release.*", which makes it sound like this isn't a good
option to go with.
The only workaround I've found is to start writing booleans as integers (0 or
1) instead, though this isn't ideal, as large numbers of existing Parquet files
are unusable.
was (Author: suicas):
Also experiencing this issue in 1.17.0.
I've been unable to find any documentation about *store.parquet.use_new_reader*
though, so am reluctant to switch to using it without knowing about any
implications.
In the options section of Drill, the documentation for it also reads "*Not
supported in this release.*", which makes it sound like this isn't a good
option to go down.
The only workaround I've found is to start writing booleans as integers (0 or
1) instead, though this isn't ideal, as large numbers of existing Parquet files
are unusable.
> Querying parquet file with boolean data type return wrong results
> -----------------------------------------------------------------
>
> Key: DRILL-7399
> URL: https://issues.apache.org/jira/browse/DRILL-7399
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Parquet
> Affects Versions: 1.16.0
> Reporter: Fabian Barreiro
> Priority: Critical
> Attachments: newrule22_3_1.parquet
>
>
> The following query return a wrong value for the boolean column press_run_1:
> SELECT * FROM dfs.root.`/tmp/newrule22_3_1.parquet` WHERE cycle_id=23435119
> The query return press_run_1 = 'false'
> the parquet file contain pess_run_1 = 'true' value for this record.
> You can find many records with this problem if try different selects.
> ATTACHED: newrule22_3_1.parquet file.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
