[DRILL-723] Parse error for LEFT function

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.1.0-m1
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: Mehant Baid
• Reporter: Krystal
• Created: 13/May/14 23:12
• Updated: 10/Jun/14 20:35
• Resolved: 10/Jun/14 20:35

Description

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" ...
.
.
.

Issue Links

• is cloned by: DRILL-721 Parse failure for RIGHT function