drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehant Baid (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2606) Casting a column from hbase to boolean after a join with parquet makes DRILL unresponsive
Date Wed, 15 Apr 2015 05:43:59 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14495694#comment-14495694

Mehant Baid commented on DRILL-2606:

+1. Minor comments

1. Could you add a more general test case as well where we are casting to a boolean type with
exchanges in the plan, this would also test the deserialization logic. 

2. In the castBit (cast from varchar to boolean) function should we use equalsIgnoreCase?

> 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
>    Affects Versions: 0.8.0
>            Reporter: Rahul Challapalli
>            Assignee: Venki Korukanti
>            Priority: Critical
>             Fix For: 0.9.0
>         Attachments: DRILL-2606-1.patch, dataload.hql, error.log, fewtypes_null.parquet,
> Small scale repro without HBase:
> {code}
> alter session set `planner.slice_target`=1;
> select cast(cast(bool_col  as varchar(100)) as boolean) from dfs.`/Users/hadoop/Downloads/fewtypes_null.parquet`
order by int_col;
> {code}
> 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

View raw message