Rahul Challapalli created DRILL-2605: ----------------------------------------
Summary: Projecting a boolean column from a hbase view after a join is causing an ExpressionParsingException Key: DRILL-2605 URL: https://issues.apache.org/jira/browse/DRILL-2605 Project: Apache Drill Issue Type: Bug Components: Storage - HBase Reporter: Rahul Challapalli Assignee: Aditya Kishore git.commit.id.abbrev=4d398ed I created a view on top of hbase table using the below DDL : {code} 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; {code} The below query fails : {code} 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 ] {code} Just projecting the boolean column from hbase succeeds {code} 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) {code} I attached the data files, hive script to load data into hbase, and the error log. Let me know if you need anything -- This message was sent by Atlassian JIRA (v6.3.4#6332)