You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jd...@apache.org on 2016/05/03 03:38:05 UTC
[48/50] [abbrv] hive git commit: HIVE-13568: UDFs for use in
column-masking - includes updates for review comments (Madhan Neethiraj via
Gunther Hagleitner)
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