[
https://issues.apache.org/jira/browse/DRILL-1438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14140609#comment-14140609
]
Jacques Nadeau commented on DRILL-1438:
---------------------------------------
[~knguyen], can you please retry the query using correct map references? We've
deprecated using brackets for map references. For example:
select substr(convert_from(t.onecf.name, 'UTF8'), 5, 8) from m7voter t where
t.twocf.age < 20;
> hbase queries fail with illegal char error
> ------------------------------------------
>
> Key: DRILL-1438
> URL: https://issues.apache.org/jira/browse/DRILL-1438
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - HBase
> Reporter: Krystal
> Attachments: server.log
>
>
> git.commit.id.abbrev=f8d38b6
> The following queries failed:
> 0: jdbc:drill:schema=M7> select substr(convert_from(onecf['name'], 'UTF8'),
> 5, 8) from m7voter where twocf['age'] < 20;
> Query failed: Failure due to uncaught exception Encountered an illegal char
> on line 1, column 28: '' [d613298d-f3c5-4b8a-b939-689ec599fafd]
> 0: jdbc:drill:schema=M7> select concat(cast(twocf['age'] as
> integer),convert_from(onecf['name'], 'UTF8'),cast(twocf['registration'] as
> varchar(20)),cast(threecf['contributions'] as decimal(6,2))) from m7voter
> where row_key=102;
> Query failed: Failure due to uncaught exception Encountered an illegal char
> on line 1, column 69: '' [a165aa5b-b454-4085-8f62-95e190e99f21]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
