drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sudheesh Katkam (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-2605) Projecting a boolean column from a hbase view after a join is causing an ExpressionParsingException
Date Tue, 14 Apr 2015 20:40:59 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sudheesh Katkam resolved DRILL-2605.
------------------------------------
    Resolution: Duplicate

Same error manifests differently. Resolving as duplicate as this has lower priority.

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

Mime
View raw message