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)