alphanumPattern

[ 1 Usage details ] [ 2 Example ]

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

LQL Command

select alphanumPattern(column) as resultCol from table

Example

Input
table = github_logs

id	col1

id	col1
1	kumar@logichub.com
2	emil@logichub.com

LQL command

select *, alphanumPattern(col1) as result from table

Output

id	col1	result

id	col1	result
1	kumar@logichub.com	aaaaa@aaaaaaa.aaa
2	emil@logichub.com	aaaa@aaaaaaa.aaa