Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB