[
https://issues.apache.org/jira/browse/CALCITE-5384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17634551#comment-17634551
]
Julian Hyde commented on CALCITE-5384:
--------------------------------------
Hopefully this is as straightforward as adding BIGQUERY to the list of
libraries in SqlLibraryOperators.java and reference.md.
> Implement LEFT/RIGHT String functions for BigQuery
> --------------------------------------------------
>
> Key: CALCITE-5384
> URL: https://issues.apache.org/jira/browse/CALCITE-5384
> Project: Calcite
> Issue Type: Task
> Reporter: Tanner Clary
> Priority: Major
>
> Implement support for the following BigQuery functions:
> * LEFT(value, length)
> ** Returns the leftmost _length_ characters of _value._ If _length_ is zero,
> an empty string or byte will be returned. If _length_ is greater than
> _length(value),_ _value_ will be returned. If _length_ is negative, an error
> will be returned.
> * RIGHT(value, length)
> ** Returns the rightmost _length_ characters of {_}value{_}. Follows the
> same edge-case behavior as LEFT().
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
