[DRILL-7399] Querying parquet file with boolean data type return wrong results

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.20.1
• Component/s: Storage - Parquet
• Assignee: James Turton
• Reporter: Fabian Barreiro
• Created: 09/Oct/19 22:21
• Updated: 19/Jul/22 07:31
• Resolved: 19/Jul/22 07:28

Description

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.