[
https://issues.apache.org/jira/browse/DRILL-2606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14494795#comment-14494795
]
Sudheesh Katkam commented on DRILL-2606:
----------------------------------------
Adding to Chris' comment, jackson is unable to parse an expression in
fragment_json (part of PlanFragment) because 'BIT' is not a recognized token in
ExprParser.java
This line in ControlHandlerImpl.java throws the exception:
{code}
final FragmentRoot rootOperator =
drillbitContext.getPlanReader().readFragmentOperator(fragment.getFragmentJson());
{code}
{code}
...
org.apache.drill.common.exceptions.ExpressionParsingException: Expression has
syntax error! line 1:65:no viable alternative at input 'BIT'
at
org.apache.drill.common.expression.parser.ExprParser.displayRecognitionError(ExprParser.java:168)
...
{code}
> Casting a column from hbase to boolean after a join with parquet makes DRILL
> unresponsive
> -----------------------------------------------------------------------------------------
>
> Key: DRILL-2606
> URL: https://issues.apache.org/jira/browse/DRILL-2606
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Affects Versions: 0.8.0
> Reporter: Rahul Challapalli
> Assignee: Sudheesh Katkam
> Priority: Critical
> Fix For: 0.9.0
>
> Attachments: dataload.hql, error.log, fewtypes_null.parquet,
> fewtypes_null_hbase.tbl
>
>
> git.commit.id.abbrev=4d398ed
> The below query never returns and causes Sqlline to hang. DRILL also becomes
> unresponsive after executing this query. So I have to restart drill for
> sqlline to even come up.
> {code}
> select cast(cast(o.types.bool_col as varchar(100)) as boolean) bool_col
> from dfs.`cross-sources`.`fewtypes_null.parquet` p
> inner join hbase.fewtypes_null o
> on p.int_col = cast(cast(o.types.int_col as varchar(100)) as int)
> {code}
> This issue is similar to DRILL-2605. However in this case I did not use a
> view and some this causes drill/sqlline to become unresponsive where in
> DRILL-2605 we just get back an error.
> I attached the data files, data loading script, and the error log. Let me
> know if you need anything else.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
