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

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

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

Mehant Baid resolved DRILL-723.
-------------------------------

    Resolution: Fixed

> 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
>            Assignee: Mehant Baid
>             Fix For: 1.0.0-BETA1
>
>
> 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)