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