You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select cityHash64((uniqExactIfState(ip_ipv4, IPv4NumToString(ip_ipv4) != '0.0.0.0'))) s from (select number::UInt32::IPv4 ip_ipv4 from numbers(5));
11633466984699233424
1151808907717399603
17831837082994141299
But cityHash64 / hex / uniqExactIfState
select cityHash64(hex(uniqExactIfState(ip_ipv4, IPv4NumToString(ip_ipv4) != '0.0.0.0'))) s from (select number::UInt32::IPv4 ip_ipv4 from numbers(5));
1753892442189903720
1753892442189903720
1753892442189903720
The text was updated successfully, but these errors were encountered:
cityHash64 / uniqExactIfState
But cityHash64 / hex / uniqExactIfState
The text was updated successfully, but these errors were encountered: