[jira] [Commented] (DRILL-2605) Projecting a boolean column from a hbase view after a join is causing an ExpressionParsingException

["Chris Westin (JIRA)" <ji...@apache.org>]

    [ 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)