You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/05/14 01:14:15 UTC

[jira] [Created] (DRILL-723) Parse error for LEFT function

Krystal created DRILL-723:
-----------------------------

             Summary: Parse error for LEFT function
                 Key: DRILL-723
                 URL: https://issues.apache.org/jira/browse/DRILL-723
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.0.0-milestone-1
            Reporter: Krystal


LEFT function fails with the following error:
select left(name, -5) from voter where age > 75
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "3e57e4d3-c553-4f8e-958b-5ada2f59b8f6"
endpoint {
  user_port: 31010
  control_port: 31011
  data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < SqlParseException:[ Encountered "left" at line 1, column 8.
Was expecting one of:
    "UNION" ...
    "INTERSECT" ...
    "EXCEPT" ...
    "ORDER" ...
.
.
.



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