[jira] [Commented] (CALCITE-5580) Add SPLIT function (enabled in BigQuery library)

["Julian Hyde (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17702982#comment-17702982 ] 

Julian Hyde commented on CALCITE-5580:
--------------------------------------

[~tanclary], I reviewed your PR. I added some extra commits to support BINARY and VARBINARY arguments; and also to make it work when you pass a string such as '.' which has a different meaning as a regex. Please see [julianhyde/5580-split|https://github.com/julianhyde/calcite/tree/5580-split].

> Add SPLIT function (enabled in BigQuery library)
> ------------------------------------------------
>
>                 Key: CALCITE-5580
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5580
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Tanner Clary
>            Assignee: Tanner Clary
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 50m
>  Remaining Estimate: 0h
>
> BigQuery offers the {{SPLIT()}} function which splits a string at an optionally-specified delimiter into a string array. If no delimiter is specified, it is default to a comma. If the string is empty, an array of a single empty string is returned. If the delimiter is not found in the string, an array with a single element (the string) is returned. 
> In BigQuery, the function can also accept bytes. In order to implement this, I think some modifications to ByteString.java may be required. I will probably not do this at least for my initial draft. If anyone has any suggestions or guidance on whether or not it should be supported, I would appreciate it. 
> Documentation and example cases may be found below.
> EXAMPLE: {{SPLIT('h,e,l,l,o')}} would return: {{[h, e, l, l, o]}}.
> EXAMPLE: {{SPLIT('h-e-l-l-o', '-')}} would return: {{[h, e, l, l, o]}}.
> [BigQuery docs|https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#split] 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)