[ https://issues.apache.org/jira/browse/DRILL-2605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14390896#comment-14390896 ]
Chris Westin commented on DRILL-2605: ------------------------------------- The remote RPC exception looks like the same one from DRILL-2396. > 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 > Affects Versions: 0.8.0 > Reporter: Rahul Challapalli > Assignee: Aditya Kishore > Fix For: 0.9.0 > > Attachments: dataload.hql, error.log, fewtypes_null.parquet, > fewtypes_null_hbase.tbl > > > 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)