You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Anton Gozhiy (JIRA)" <ji...@apache.org> on 2018/05/14 10:21:00 UTC

[jira] [Updated] (DRILL-6413) Specific query returns an exception if filter a boolean column by "equals" operator

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

Anton Gozhiy updated DRILL-6413:
--------------------------------
    Description: 
*Data:*
 Use the attached dataset

*Query:*
{code:sql}
 select *
 from dfs.tmp.`Test_data`
 where bool_col = true and part_col in ('Partition_two')
{code}

*Expected result:*
 The query should return result normally

*Actual result:*
 Exception happens:
{noformat}
Error: SYSTEM ERROR: ClassCastException: org.apache.drill.common.expression.TypedFieldExpr cannot be cast to org.apache.drill.exec.expr.stat.ParquetFilterPredicate
{noformat}
*Notes:*
 It works OK if use "is" operator or if not use "*" in the select statement

  was:
*Data:*
Use the attached dataset

*Query:*
select *
from dfs.tmp.`Test_data`
where bool_col = true and part_col in ('Partition_two')

*Expected result:*
The query should return result normally

*Actual result:*
Exception happens:
{noformat}
Error: SYSTEM ERROR: ClassCastException: org.apache.drill.common.expression.TypedFieldExpr cannot be cast to org.apache.drill.exec.expr.stat.ParquetFilterPredicate
{noformat}

*Notes:*
It works OK if use "is" operator or if not use "*" in the select statement


> Specific query returns an exception if filter a boolean column by "equals" operator
> -----------------------------------------------------------------------------------
>
>                 Key: DRILL-6413
>                 URL: https://issues.apache.org/jira/browse/DRILL-6413
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Anton Gozhiy
>            Priority: Major
>         Attachments: Test_data.tar.gz
>
>
> *Data:*
>  Use the attached dataset
> *Query:*
> {code:sql}
>  select *
>  from dfs.tmp.`Test_data`
>  where bool_col = true and part_col in ('Partition_two')
> {code}
> *Expected result:*
>  The query should return result normally
> *Actual result:*
>  Exception happens:
> {noformat}
> Error: SYSTEM ERROR: ClassCastException: org.apache.drill.common.expression.TypedFieldExpr cannot be cast to org.apache.drill.exec.expr.stat.ParquetFilterPredicate
> {noformat}
> *Notes:*
>  It works OK if use "is" operator or if not use "*" in the select statement



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)