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)
