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.
select alphanumPattern(column) as resultCol from table
table = github_logs
select *, alphanumPattern(col1) as result from table
Updated over 2 years ago