Hive SQL can be used to collect most data from hive, yes. There is also Hivemind and other systems that act as middlewear for indexing. I haven't used them for this kind of indexing myself yet though. I will probably get to it in time. Proper notifications are a higher priority at the moment.