Repository: hive Updated Branches: refs/heads/master d5285d8eb -> e9a72189e
http://git-wip-us.apache.org/repos/asf/hive/blob/e9a72189/ql/src/test/results/clientpositive/udf_mask_show_last_n.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udf_mask_show_last_n.q.out b/ql/src/test/results/clientpositive/udf_mask_show_last_n.q.out new file mode 100644 index 0000000..3bf2e62 --- /dev/null +++ b/ql/src/test/results/clientpositive/udf_mask_show_last_n.q.out @@ -0,0 +1,68 @@ +PREHOOK: query: DESCRIBE FUNCTION mask_show_last_n +PREHOOK: type: DESCFUNCTION +POSTHOOK: query: DESCRIBE FUNCTION mask_show_last_n +POSTHOOK: type: DESCFUNCTION +masks all but last n characters of the value +PREHOOK: query: DESC FUNCTION EXTENDED mask_show_last_n +PREHOOK: type: DESCFUNCTION +POSTHOOK: query: DESC FUNCTION EXTENDED mask_show_last_n +POSTHOOK: type: DESCFUNCTION +masks all but last n characters of the value +Examples: + mask_show_last_n(ccn, 8) + mask_show_last_n(ccn, 8, 'x', 'x', 'x') + Arguments: + mask_show_last_n(value, charCount, upperChar, lowerChar, digitChar, otherChar, numberChar) + value - value to mask. Supported types: TINYINT, SMALLINT, INT, BIGINT, STRING, VARCHAR, CHAR + charCount - number of characters. Default value: 4 + upperChar - character to replace upper-case characters with. Specify -1 to retain original character. Default value: 'X' + lowerChar - character to replace lower-case characters with. Specify -1 to retain original character. Default value: 'x' + digitChar - character to replace digit characters with. Specify -1 to retain original character. Default value: 'n' + otherChar - character to replace all other characters with. Specify -1 to retain original character. Default value: -1 + numberChar - character to replace digits in a number with. Valid values: 0-9. Default value: '1' + +PREHOOK: query: explain select mask_show_last_n('TestString-123', 4, 'X', 'x', '0', '1') +PREHOOK: type: QUERY +POSTHOOK: query: explain select mask_show_last_n('TestString-123', 4, 'X', 'x', '0', '1') +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-0 is a root stage + +STAGE PLANS: + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + TableScan + alias: _dummy_table + Row Limit Per Split: 1 + Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE + Select Operator + expressions: 'XxxxXxxxxx-123' (type: string) + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: COMPLETE + ListSink + +PREHOOK: query: select mask_show_last_n('TestString-123', 4, 'X', 'x', '0', ':'), + mask_show_last_n(cast('TestString-123' as varchar(24)), 4, 'X', 'x', '0', ':'), + mask_show_last_n(cast('TestString-123' as char(24)), 4, 'X', 'x', '0', ':'), + mask_show_last_n(cast(123 as tinyint), 4, -1, -1, -1, -1, '5'), + mask_show_last_n(cast(12345 as smallint), 4, -1, -1, -1, -1, '5'), + mask_show_last_n(cast(12345 as int), 4, -1, -1, -1, -1, '5'), + mask_show_last_n(cast(12345 as bigint), 4, -1, -1, -1, -1, '5'), + mask_show_last_n(cast('2016-04-20' as date), 4, -1, -1, -1, -1, -1, 0, 0, 0) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### +POSTHOOK: query: select mask_show_last_n('TestString-123', 4, 'X', 'x', '0', ':'), + mask_show_last_n(cast('TestString-123' as varchar(24)), 4, 'X', 'x', '0', ':'), + mask_show_last_n(cast('TestString-123' as char(24)), 4, 'X', 'x', '0', ':'), + mask_show_last_n(cast(123 as tinyint), 4, -1, -1, -1, -1, '5'), + mask_show_last_n(cast(12345 as smallint), 4, -1, -1, -1, -1, '5'), + mask_show_last_n(cast(12345 as int), 4, -1, -1, -1, -1, '5'), + mask_show_last_n(cast(12345 as bigint), 4, -1, -1, -1, -1, '5'), + mask_show_last_n(cast('2016-04-20' as date), 4, -1, -1, -1, -1, -1, 0, 0, 0) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### +XxxxXxxxxx-123 XxxxXxxxxx-123 XxxxXxxxxx:000:::::: 123 -13191 52345 52345 1900-01-01
