Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hadoop, mail # user - Hbase & Hive


+
Amit Kumar 2010-04-30, 04:23
+
Jean-Daniel Cryans 2010-04-30, 16:55
Copy link to this message
-
Re: Hbase & Hive
Nick Dimiduk 2010-04-30, 22:43
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 <[EMAIL PROTECTED]>wrote:

> Inline (and added hbase-user to the recipients).
>
> J-D
>
> On Thu, Apr 29, 2010 at 9:23 PM, Amit Kumar <[EMAIL PROTECTED]> 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
> >
>
+
Sonal Goyal 2010-05-01, 04:13
+
Edward Capriolo 2010-05-01, 04:46