[
https://issues.apache.org/jira/browse/DRILL-2606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venki Korukanti updated DRILL-2606:
-----------------------------------
Attachment: DRILL-2606-2.patch
Uploading v2 patch. Added e2e test case involveing multi fragment run.
> 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
(v6.3.4#6332)
