Hi Bejoy I am not looking for just an UI for queries (even though at first, when working on twitter data, that was of my interest). But, now I am planning on using Hive as a warehouse with a front end in-memory processing engine. Microstrategy or tableau would be a good choice.
Now further refining the problem, I would ask what is the warehousing power of Hive when compared to a traditional warehouse. Can Hive perform all operations performed/required in a warehouse. If not, where are the short comings which I need to deal with. Always thankful for your apt assistance. On Mon, Jun 4, 2012 at 3:49 PM, Bejoy Ks <bejoy...@yahoo.com> wrote: > 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. > > >
