Rahul Challapalli created DRILL-1486:
----------------------------------------
Summary: Hbase : Using substring together with convert_from fails
to execute
Key: DRILL-1486
URL: https://issues.apache.org/jira/browse/DRILL-1486
Project: Apache Drill
Issue Type: Bug
Components: Storage - HBase
Reporter: Rahul Challapalli
git.commit.id.abbrev=5c220e3
The below query fails :
{code}
select substr(convert_from(onecf['name'], 'UTF8'), 5, 8) from voter;
Query failed: Failure due to uncaught exception Encountered an illegal char on
line 1, column 36: '' [636dc357-ba36-42ad-8e33-ae3bb82f18f9]
Error: exception while executing query: Failure while trying to get next result
batch. (state=,code=0)
{code}
However individual functions seem to work. The below 2 queries work as expected
{code}
select convert_from(onecf['name'], 'UTF8') from voter
select substr(onecf['name'], 5, 8) from voter;
{code}
I attached the data and the error log
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
