[ https://issues.apache.org/jira/browse/DRILL-1486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aman Sinha updated DRILL-1486: ------------------------------ Component/s: (was: SQL Parser) Functions - Drill > 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: 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)