drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1486) Hbase : Using substring together with convert_from fails to execute
Date Sun, 04 Jan 2015 21:27:49 GMT

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

Jacques Nadeau updated DRILL-1486:
----------------------------------
      Component/s:     (was: Storage - HBase)
                   SQL Parser
    Fix Version/s: 0.9.0
         Assignee: Jason Altekruse

> 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: SQL Parser
>            Reporter: Rahul Challapalli
>            Assignee: Jason Altekruse
>             Fix For: 0.9.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)

Mime
View raw message