[DRILL-2605] Projecting a boolean column from a hbase view after a join is causing an ExpressionParsingException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.8.0
• Fix Version/s: 0.9.0
• Component/s: Storage - HBase
• Assignee: Aditya Kishore
• Reporter: Rahul Kumar Challapalli
• Created: 27/Mar/15 18:00
• Updated: 06/May/15 22:53
• Resolved: 14/Apr/15 20:40

Description

git.commit.id.abbrev=4d398ed

I created a view on top of hbase table using the below DDL :

create or replace view dfs.`cross-sources`.fewtypes_null_hbase_booleanbug_view as
select
    cast(cast(a.types.int_col as varchar(100)) as int) int_col,
    cast(cast(a.types.bool_col as varchar(100)) as boolean) bool_col
from hbase.fewtypes_null a;

The below query fails :

select o.bool_col
from dfs.`cross-sources`.`fewtypes_null.parquet` p
inner join dfs.`cross-sources`.fewtypes_null_hbase_booleanbug_view o
    on p.int_col=o.int_col;
Query failed: RemoteRpcException: Failure while trying to start remote fragment, Expression has syntax error! line 1:65:no viable alternative at input 'BIT' [ 6e771b83-e3e3-405d-b738-1cd7ee8d5cb5 on qa-node114.qa.lab:31010 ]

Just projecting the boolean column from hbase succeeds

select o.bool_col from dfs.`cross-sources`.fewtypes_null_hbase_booleanbug_view o;
+------------+
|  bool_col  |
+------------+
| false      |
| false      |
| true       |
| false      |
| false      |
| true       |
| false      |
| true       |
| true       |
| false      |
| true       |
| false      |
| false      |
| false      |
| true       |
| false      |
| true       |
+------------+
17 rows selected (1.366 seconds)

I attached the data files, hive script to load data into hbase, and the error log. Let me know if you need anything

Issue Links

• duplicates: DRILL-2606 Casting a column from hbase to boolean after a join with parquet makes DRILL unresponsive
• is related to: DRILL-2396 Query with IS [NOT] DISTINCT FROM in join filter fails during execution if planner.slice_target=1