[jira] [Resolved] (DRILL-725) SUBSTRING/SUBSTR(string, from) function fails

["Mehant Baid (JIRA)" <ji...@apache.org>]

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

Mehant Baid resolved DRILL-725.
-------------------------------

    Resolution: Fixed

> SUBSTRING/SUBSTR(string, from) function fails
> ---------------------------------------------
>
>                 Key: DRILL-725
>                 URL: https://issues.apache.org/jira/browse/DRILL-725
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>    Affects Versions: 1.0.0-milestone-1
>            Reporter: Krystal
>            Assignee: Mehant Baid
>             Fix For: 1.0.0-BETA1
>
>
> The SUBSTR/SUBSTRING function without the optional count parameter fails.  If the count parameter is missing, it suppose to return the data at "from" to the end of the string.  
> Below is the failure:
> select substr(name, 3) from voter where voter_id=10
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "99e0ed96-0109-40a4-a636-cf673b161670"
> endpoint {
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < RuntimeException:[ GenericUDF.evaluate method failed ] < UnsupportedOperationException"
> ]
> java.sql.SQLException: exception while executing query
>         at net.hydromatic.avatica.Helper.createException(Helper.java:40)
>         at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:406)
>         at net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:350)
>         at net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:78)
>         at org.apache.drill.test.framework.QuerySubmitter.submitQueryJDBC(QuerySubmitter.java:90)
>         at org.apache.drill.test.framework.DrillTestBase$RunThread.run(DrillTestBase.java:262)
> Caused by: java.sql.SQLException: Failure while trying to get next result batch.
>         at org.apache.drill.jdbc.DrillCursor.next(DrillCursor.java:101)
>         at org.apache.drill.jdbc.DrillResultSet.execute(DrillResultSet.java:89)
>         at org.apache.drill.jdbc.DrillResultSet.execute(DrillResultSet.java:43)
>         at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)



--
This message was sent by Atlassian JIRA
(v6.2#6252)