[jira] [Updated] (DRILL-1486) Hbase : Using substring together with convert_from fails to execute

["Jason Altekruse (JIRA)" <ji...@apache.org>]

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

Jason Altekruse updated DRILL-1486:
-----------------------------------
    Fix Version/s:     (was: 0.9.0)
                   1.0.0

> 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: Functions - Drill
>            Reporter: Rahul Challapalli
>            Assignee: Jason Altekruse
>             Fix For: 1.0.0
>
>         Attachments: error.txt, votertab
>
>
> 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)