drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1486) Hbase : Using substring together with convert_from fails to execute
Date Fri, 03 Oct 2014 00:23:33 GMT
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)

Mime
View raw message