[
https://issues.apache.org/jira/browse/DRILL-6413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anton Gozhiy closed DRILL-6413.
-------------------------------
Verified in Drill version 1.14.0-SNAPSHOT (commit id:
1355bfddb1c76462366e28ff7f98fdb6823b4b2a)
Cases checked:
- Original steps
- Tried selecting with star, column names and both
- Distinct, aggregate functions
- Subqueries
- Union
- Join
- Tried different columns in filter, and also used NOT and '<>' operators
- Order by
- Having
> 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
> Assignee: Arina Ielchiieva
> Priority: Major
> Labels: ready-to-commit
> Fix For: 1.14.0
>
> 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)
