alphanumPattern

Convert input into an alpha pattern.

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

select *, alphanumPattern(col1) as result from table

Output


© 2017-2021 LogicHub®. All Rights Reserved.