blob: 82ab2f619705b96e4b8ab62533b38f2e8295b567 [file] [log] [blame]
PREHOOK: query: DESCRIBE FUNCTION rpad
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION rpad
POSTHOOK: type: DESCFUNCTION
rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
PREHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
POSTHOOK: type: DESCFUNCTION
rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
If str is longer than len, the return value is shortened to len characters.
In case of empty pad string, the return value is null.
Example:
> SELECT rpad('hi', 5, '??') FROM src LIMIT 1;
'hi???'
> SELECT rpad('hi', 1, '??') FROM src LIMIT 1;
'h'
> SELECT rpad('hi', 5, '') FROM src LIMIT 1;
null
Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFRpad
Function type:BUILTIN
PREHOOK: query: EXPLAIN SELECT
rpad('hi', 1, '?'),
rpad('hi', 5, '.'),
rpad('hi', 6, '123')
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: EXPLAIN SELECT
rpad('hi', 1, '?'),
rpad('hi', 5, '.'),
rpad('hi', 6, '123')
FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
STAGE DEPENDENCIES:
Stage-0 is a root stage
STAGE PLANS:
Stage: Stage-0
Fetch Operator
limit: -1
Processor Tree:
TableScan
alias: src
Row Limit Per Split: 1
Select Operator
expressions: 'h' (type: string), 'hi...' (type: string), 'hi1231' (type: string)
outputColumnNames: _col0, _col1, _col2
ListSink
PREHOOK: query: SELECT
rpad('hi', 1, '?'),
rpad('hi', 5, '.'),
rpad('hi', 6, '123')
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT
rpad('hi', 1, '?'),
rpad('hi', 5, '.'),
rpad('hi', 6, '123')
FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
h hi... hi1231