273k distinct string values (domain names) being grouped the I was able to see 5% reduction in runtime. This is a 5% reduction of the total time -- including decoding / decompressing input columns / network traffic -- so a nice and easy gain.
I imagine it's a pretty simple switch for you guys since Google invented CityHash.