[
https://issues.apache.org/jira/browse/BEAM-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rui Wang closed BEAM-5945.
--------------------------
Resolution: Done
Fix Version/s: Not applicable
> REVERSE
> -------
>
> Key: BEAM-5945
> URL: https://issues.apache.org/jira/browse/BEAM-5945
> Project: Beam
> Issue Type: Sub-task
> Components: dsl-sql
> Reporter: Rui Wang
> Assignee: Rui Wang
> Priority: Major
> Fix For: Not applicable
>
>
> REVERSE(value)
> Returns the reverse of the input STRING or BYTES.
> Return type
> STRING or BYTES
> Examples
> WITH example AS (
> SELECT "foo" AS sample_string, b"bar" AS sample_bytes UNION ALL
> SELECT "абвгд" AS sample_string, b"123" AS sample_bytes
> )
> SELECT
> sample_string,
> REVERSE(sample_string) AS reverse_string,
> sample_bytes,
> REVERSE(sample_bytes) AS reverse_bytes
> FROM example;
> +---------------+----------------+--------------+---------------+
> | sample_string | reverse_string | sample_bytes | reverse_bytes |
> +---------------+----------------+--------------+---------------+
> | foo | oof | bar | rab |
> | абвгд | дгвба | 123 | 321 |
> +---------------+----------------+--------------+---------------+
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)