Hi all I am new to hive and am working on analysis of twitter data with Hive and Hadoop in a 27node cluster. At present am using Microsoft powerpivot as the visualization tool for visual representation of analysis done using Hive and have got some really good results and I am stunned by the scalability power of the Hadoop system.
As a next step, I would like to evaluate the warehousing capabilities of Hive for business data. Any insights into this is welcome. And am facing problem of delegating job to Hive/Powerpivot as Powerpivot itself has capabilities of being a warehouse tool. Any other good visualization tools for usage with Hive is also welcome. For analyzing twitter data, I just ran complex Hive queries for each of analysis done. But for a warehouse, this does not sound like a good solution. Any help is greatly appreciated. Thanks.
