Both the Hive webrequest table and Druid webrequest_sampled_128 have the x-cache header, e.g. cp1082 hit, cp1076 hit/19752.

But only the Hive webrequest table has the rolled-up cache_status field, with more convenient values like hit-front or miss or pass.

It'd be nice to have that in Druid/Turnilo as well; I find myself constructing regexes over the x_cache field there quite often.