If you are looking for an ORM layer for HBase, there is one at http://github.com/enis/gora
Thanks and Regards, Sonal www.meghsoft.com On Sat, May 1, 2010 at 4:13 AM, Nick Dimiduk <ndimi...@gmail.com> wrote: > If by "efficiently", you mean "low latency" then no, you will not get > ms-response time for your hive queries over hbase as the hive query planner > still results in m/r jobs being run over the cluster. > > Hope that helps. > > Cheers, > -Nick > > On Fri, Apr 30, 2010 at 9:55 AM, Jean-Daniel Cryans <jdcry...@apache.org > >wrote: > > > Inline (and added hbase-user to the recipients). > > > > J-D > > > > On Thu, Apr 29, 2010 at 9:23 PM, Amit Kumar <amkumar....@gmail.com> > wrote: > > > Hi Everyone, > > > > > > I want to ask about Hbase and Hive. > > > > > > Q1> Is there any dialect available which can be used with Hibernate to > > > create persistence with Hbase. Has somebody written one. I came across > > HBql > > > at > > > www.hbql.com. Can this be used to create a dialect for Hbase? > > > > HBQL queries HBase directly, but it's not SQL-compliant and doesn't > > feature relational keywords (since HBase doesn't support them, JOINs > > don't scale). I don't know if anybody tried integrating HBQL in > > Hibernate... it's still a very young project. > > > > > > > > Q2> Once the data is in there in Hbase. In this link I found that it > can > > be > > > used with Hive ( https://issues.apache.org/jira/browse/HIVE-705 ). So > > the > > > question is is it safe enough to use the below architecture for > > application > > > Hibernate --> Dialect for Hbase --> Hbase --> query from Hbase using > Hive > > to > > > use MapReduce effectively. > > > > Hive goes on top of HBase, so you can use its query language to mine > > HBase tables. Be aware that a MapReduce job isn't meant for live > > queries, so issuing them from Hibernate doesn't make much sense... > > unless you meant something else and this which case please do give > > more details. > > > > > > > > Thanks & Regards > > > Amit Kumar > > > > > >