I am trying to perform low latency lookups on clickhouse.

CREATE TABLE example.events_data ( event_time DateTime, user_id UInt64, event_id UUID, lookup_hash UInt64 MATERIALIZED cityHash64(user_id, event_id) ) ENGINE = MergeTree PARTITION BY toYYYYMM(event_time) ORDER BY lookup_hash SETTINGS index_granularity = 256;

Now if example.events_data contains 5 billion rows and I want to pull out 500 rows from it on the basis of lookup_hash,
something like
select * from example.events_data where lookup_hash in (select lookup_hash from another table where some condition limit 500)

How can we achieve this with low latency?