Thanks. Impala is an alternative to Hive as I understand. What I am looking for is a tool that I can couple to Hive as the repository. I still think Oracle TimesTen will do the job.
On 25/8/2015, "Daniel Haviv" <[email protected]> wrote: >Hi, >There is a myriad of solutions, among them: >Impala >Presto >Drill >Kylin >Tajo > > >On Tue, Aug 25, 2015 at 10:44 AM, Mich Talebzadeh <[email protected]> >wrote: > >> Hi, >> >> >> >> My question concerns the means of presenting data to consumer layer from >> Hive. >> >> >> >> Obviously Hive is very suitable for batch analysis. However, the MapReduce >> nature of extracting data make is unlikely as a direct access tool for >> consumer layer. >> >> >> >> So my question is what products are there that can be used effectively to >> get the data from Hive to visualisations tools like Tableau. >> >> >> >> I thought of using Oracle TimesTen in-memory database to get the data out >> of Hive/Hadoop and keep the most frequently used data in memory. What are >> other alternatives around? >> >> >> >> Thanks, >> >> >> >> >> >> Mich Talebzadeh >> >> >> >> *Sybase ASE 15 Gold Medal Award 2008* >> >> A Winning Strategy: Running the most Critical Financial Data on ASE 15 >> >> >> http://login.sybase.com/files/Product_Overviews/ASE-Winning-Strategy-091908.pdf >> >> Author of the books* "A Practitionerâs Guide to Upgrading to Sybase ASE >> 15", ISBN 978-0-9563693-0-7*. >> >> co-author *"Sybase Transact SQL Guidelines Best Practices", ISBN >> 978-0-9759693-0-4* >> >> *Publications due shortly:* >> >> *Complex Event Processing in Heterogeneous Environments*, ISBN: >> 978-0-9563693-3-8 >> >> *Oracle and Sybase, Concepts and Contrasts*, ISBN: 978-0-9563693-1-4, volume >> one out shortly >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> NOTE: The information in this email is proprietary and confidential. This >> message is for the designated recipient only, if you are not the intended >> recipient, you should destroy it immediately. Any information in this >> message shall not be understood as given or endorsed by Peridale Technology >> Ltd, its subsidiaries or their employees, unless expressly so stated. It is >> the responsibility of the recipient to ensure that this email is virus >> free, therefore neither Peridale Ltd, its subsidiaries nor their employees >> accept any responsibility. >> >> >> > >
