tanclary opened a new pull request, #3109:
URL: https://github.com/apache/calcite/pull/3109
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)
[JIRA Case](https://issues.apache.org/jira/browse/CALCITE-5580)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
