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 12 months ago