The solution is to use SQL views, materialized views, or create a new table that contains only the filtered data the user needs.

Airbnb created Riverbed, a Lambda-like data framework for producing and managing distributed materialized views. The framework supports over 50 read-heavy use cases where data is sourced from ...