Rahul Challapalli created DRILL-2606:
----------------------------------------
Summary: Casting a column from hbase to boolean after a join with
parquet makes DRILL unresponsive
Key: DRILL-2606
URL: https://issues.apache.org/jira/browse/DRILL-2606
Project: Apache Drill
Issue Type: Bug
Components: Execution - Flow, Storage - HBase
Reporter: Rahul Challapalli
Assignee: Chris Westin
Priority: Critical
git.commit.id.abbrev=4d398ed
The below query never returns and causes Sqlline to hang. DRILL also becomes
unresponsive after executing this query. So I have to restart drill for sqlline
to even come up.
{code}
select cast(cast(o.types.bool_col as varchar(100)) as boolean) bool_col
from dfs.`cross-sources`.`fewtypes_null.parquet` p
inner join hbase.fewtypes_null o
on p.int_col = cast(cast(o.types.int_col as varchar(100)) as int)
{code}
This issue is similar to DRILL-2605. However in this case I did not use a view
and some this causes drill/sqlline to become unresponsive where in DRILL-2605
we just get back an error.
I attached the data files, data loading script, and the error log. Let me know
if you need anything else.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
