[CALCITE-3005] Implement string functions: LEFT, RIGHT

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Labels: pull-request-available
• Assignee: Forward Xu
• Reporter: Forward Xu
• Created: 16/Apr/19 07:55
• Updated: 15/Nov/22 22:16
• Resolved: 03/Jun/19 18:19

Description

Some string functions including LEFT, RIGHT are not implemented now. It would be great if these functions can be implemented.

LEFT(str,len)

Returns the leftmost len characters from the string str, or NULL if any argument is NULL.

RIGHT(str,len)

Returns the rightmost len characters from the string str, or NULL if any argument is NULL.

Issue Links

• is a parent of: CALCITE-5384 Implement LEFT/RIGHT String functions for BigQuery
• links to: GitHub Pull Request #1168