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 > > >