[jira] [Resolved] (DRILL-721) Parse failure for RIGHT function

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

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

Mehant Baid resolved DRILL-721.
-------------------------------

    Resolution: Invalid

LEFT is a reserved keyword, used in JOIN syntax. Escape LEFT keyword with backticks.

 select `left`('abcdef', 2) from dfs.`/tmp/input.json`;
+------------+
|   EXPR$0   |
+------------+
| ab         |
+------------+

> Parse failure for RIGHT function
> --------------------------------
>
>                 Key: DRILL-721
>                 URL: https://issues.apache.org/jira/browse/DRILL-721
>             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 RIGHT function fails with the following error:
> select right(name, '6') from voter where name like 'victor%';
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "0d292a76-98ba-4c10-80c1-8e374db23e7f"
> endpoint {
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < SqlParseException:[ Encountered "right" at line 1, column 8.
> Was expecting one of:
>     "UNION" ...
>     "INTERSECT" ...
>     "EXCEPT" ...
> .
> .
> .



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