PREHOOK: query: DESCRIBE FUNCTION lpad PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION lpad POSTHOOK: type: DESCFUNCTION lpad(str, len, pad) - Returns str, left-padded with pad to a length of len PREHOOK: query: DESCRIBE FUNCTION EXTENDED lpad PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED lpad POSTHOOK: type: DESCFUNCTION lpad(str, len, pad) - Returns str, left-padded with pad to a length of len If str is longer than len, the return value is shortened to len characters. Example: > SELECT lpad('hi', 5, '??') FROM src LIMIT 1; '???hi' > SELECT lpad('hi', 1, '??') FROM src LIMIT 1; 'h' PREHOOK: query: EXPLAIN SELECT lpad('hi', 1, '?'), lpad('hi', 5, '.'), lpad('hi', 6, '123') FROM src tablesample (1 rows) PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT lpad('hi', 1, '?'), lpad('hi', 5, '.'), lpad('hi', 6, '123') FROM src tablesample (1 rows) POSTHOOK: type: QUERY 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 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 'h' (type: string), '...hi' (type: string), '1231hi' (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 500 Data size: 132000 Basic stats: COMPLETE Column stats: COMPLETE ListSink PREHOOK: query: SELECT lpad('hi', 1, '?'), lpad('hi', 5, '.'), lpad('hi', 6, '123') FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT lpad('hi', 1, '?'), lpad('hi', 5, '.'), lpad('hi', 6, '123') FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### h ...hi 1231hi