[jira] [Closed] (BEAM-5965) RPAD

["Rui Wang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/BEAM-5965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rui Wang closed BEAM-5965.
--------------------------
       Resolution: Fixed
    Fix Version/s: Not applicable

> RPAD
> ----
>
>                 Key: BEAM-5965
>                 URL: https://issues.apache.org/jira/browse/BEAM-5965
>             Project: Beam
>          Issue Type: Sub-task
>          Components: dsl-sql
>            Reporter: Rui Wang
>            Assignee: Rui Wang
>            Priority: Major
>             Fix For: Not applicable
>
>
> RPAD(original_value, return_length[, pattern])
> Returns a value that consists of original_value appended with pattern. The return_length is an INT64 that specifies the length of the returned value. If original_value is BYTES, return_length is the number of bytes. If original_value is STRING, return_length is the number of characters.
> The default value of pattern is a blank space.
> Both original_value and pattern must be the same data type.
> If return_length is less than or equal to the original_value length, this function returns the original_value value, truncated to the value of return_length. For example, RPAD("hello world", 7); returns "hello w".
> If original_value, return_length, or pattern is NULL, this function returns NULL.
> This function returns an error if:
> return_length is negative
> pattern is empty
> Return type
> STRING or BYTES
> Examples
> SELECT t, len, FORMAT("%T", RPAD(t, len)) AS RPAD FROM UNNEST([
>   STRUCT('abc' AS t, 5 AS len),
>   ('abc', 2),
>   ('例子', 4)
> ]);
> t	len	RPAD
> abc	5	"abc  "
> abc	2	"ab"
> 例子	4	"例子  "
> SELECT t, len, pattern, FORMAT("%T", RPAD(t, len, pattern)) AS RPAD FROM UNNEST([
>   STRUCT('abc' AS t, 8 AS len, 'def' AS pattern),
>   ('abc', 5, '-'),
>   ('例子', 5, '中文')
> ]);
> t	len	pattern	RPAD
> abc	8	def	"abcdefde"
> abc	5	-	"abc--"
> 例子	5	中文	"例子中文中"
> SELECT FORMAT("%T", t) AS t, len, FORMAT("%T", RPAD(t, len)) AS RPAD FROM UNNEST([
>   STRUCT(b'abc' AS t, 5 AS len),
>   (b'abc', 2),
>   (b'\xab\xcd\xef', 4)
> ]);
> t	len	RPAD
> b"abc"	5	b"abc  "
> b"abc"	2	b"ab"
> b"\xab\xcd\xef"	4	b"\xab\xcd\xef "
> SELECT
>   FORMAT("%T", t) AS t,
>   len,
>   FORMAT("%T", pattern) AS pattern,
>   FORMAT("%T", RPAD(t, len, pattern)) AS RPAD
> FROM UNNEST([
>   STRUCT(b'abc' AS t, 8 AS len, b'def' AS pattern),
>   (b'abc', 5, b'-'),
>   (b'\xab\xcd\xef', 5, b'\x00')
> ]);
> t	len	pattern	RPAD
> b"abc"	8	b"def"	b"abcdefde"
> b"abc"	5	b"-"	b"abc--"
> b"\xab\xcd\xef"	5	b"\x00"	b"\xab\xcd\xef\x00\x00"



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)