alphanumPattern

Convert each character and digit in an input string to the character 'a' and leave the rest of the string as-is. This operator allows you to group events by patterns rather than actual values or to transform values into patterns and then group by the patterns.

Usage Details

select alphanumPattern(column) as resultCol from table

Example

Input
table = github_logs

id	col1
1	[email protected]
2	[email protected]

select *, alphanumPattern(col1) as result from table

Output

id	col1	result
1	[email protected]	[email protected]
2	[email protected]	[email protected]