drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-725) SUBSTRING/SUBSTR(string, from) function fails
Date Mon, 16 Jun 2014 15:38:02 GMT

    [ https://issues.apache.org/jira/browse/DRILL-725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14032568#comment-14032568
] 

Krystal commented on DRILL-725:
-------------------------------

git.commit.id.abbrev=4198a17

Verified that bug is 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)

Mime
View raw message