[
https://issues.apache.org/jira/browse/DRILL-725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-725:
---------------------------------
Assignee: Mehant Baid
> 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
>
> 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)
