drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2606) Casting a column from hbase to boolean after a join with parquet makes DRILL unresponsive
Date Fri, 27 Mar 2015 18:17:54 GMT
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)

Mime
View raw message