generalizeInt
Generalize int type.
Return "$int$" if a string is convertible to an integer; otherwise return the input string. Useful for log obfuscation.
Usage Details
select generalizeInt(column) as resultCol from table
Example
Input
table
| date |
|---|
| 2017-04-11T04:32:51Z |
| 2017 |
select *, generalizeInt(date) as a resultCol from table
Output
| date | resultCol |
|---|---|
| 2017-04-11T04:32:51Z | 2017-04-11T04:32:51Z |
| 2017 | $int$ |
Updated about 1 year ago