This should give you an idea of the amount of indexing and querying that is possible. This is already built and operating on hive and pulls hundreds of thousands of podcasts to its index: https://tiles.podping.org/
I’m sure @brianoflondon can further clarify regarding hives ability to index and query at scale