drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-725) SUBSTRING/SUBSTR(string, from) function fails
Date Tue, 13 May 2014 23:26:15 GMT
Krystal created DRILL-725:
-----------------------------

             Summary: 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


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