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:51Z2017-04-11T04:32:51Z
2017$long$

© 2017-2021 LogicHub®. All Rights Reserved.