drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Venki Korukanti (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 15:04:00 GMT

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

Venki Korukanti commented on DRILL-2606:

bq.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.
patch v2 adds one more test case
bq. 2. In the castBit (cast from varchar to boolean) function should we use equalsIgnoreCase?
This seems like a bug in cast function implementation. Will log a separate JIRA.

> 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, DRILL-2606-2.patch, dataload.hql, error.log,
fewtypes_null.parquet, fewtypes_null_hbase.tbl
> 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