NiXuB86

I have the same problem with my Mikrotik hap ac2 and use IPFIX. SamplingRate is 0 for every sample. Also there is problem with SQL queries i think(I'm not sure)...

@amichalu Do you know the best way how to invert it back?

No, that not regard only mikrotik, because as i said before, i captured traffic on docker bridge, and in IPFIX packets IP addresses is fine.

I just tried to use netflow v9 instead of IPFIX, no difference in ClickHouse i have only inverted addresses and normal in netflow packets. Also with this query i have...

I finally found a problem! It's caused by this function in query reinterpretAsUInt32(), it converts data to UInt32 and little endian from big endian, and IPv4NumToString() function expects UInt32 big...

So I finally fixed it with this query:  Normal IPv4: IPv4NumToString(reinterpretAsUInt32(substring(reverse(SrcAddr), 13, 4))) Inverted: IPv4NumToString(reinterpretAsUInt32(reverse(SrcAddr))) And now I have the same problem with SamplingRate=0