Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Duplicate
-
0.8.0
-
None
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
Attachments
Attachments
Issue Links
- duplicates
-
DRILL-2606 Casting a column from hbase to boolean after a join with parquet makes DRILL unresponsive
- Closed
- is related to
-
DRILL-2396 Query with IS [NOT] DISTINCT FROM in join filter fails during execution if planner.slice_target=1
- Open