[ https://issues.apache.org/jira/browse/DRILL-2605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli updated DRILL-2605: ------------------------------------- Attachment: fewtypes_null.parquet fewtypes_null_hbase.tbl dataload.hql error.log > 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 > 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)