Hi Sreenath If you are looking at a UI for queries then Cloudera's hue is the best choice. Also you do have odbc connectors that integrates BI tools like microstrategy, tableau etc with hive.
Regards Bejoy KS ________________________________ From: Sreenath Menon <sreenathmen...@gmail.com> To: user@hive.apache.org Sent: Monday, June 4, 2012 2:42 PM Subject: Front end visualization tool with Hive (when using as a warehouse) 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.