You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Fabian Barreiro (Jira)" <ji...@apache.org> on 2019/10/09 22:28:00 UTC

[jira] [Updated] (DRILL-7399) Querying parquet file with boolean data type return wrong results

     [ https://issues.apache.org/jira/browse/DRILL-7399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fabian Barreiro updated DRILL-7399:
-----------------------------------
    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.


  was:
The follogin 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.



> 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)