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)