hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Daniel Cryans <jdcry...@apache.org>
Subject Re: Performance: hive+hbase integration query against the row_key
Date Wed, 12 Sep 2012 17:11:59 GMT
On Tue, Sep 11, 2012 at 6:56 AM, Shengjie Min <shengjie.min@gmail.com> wrote:
> 1. if you do a hive query against the row key like "select * from
> hive_hbase_test where key='blabla'", this would utilize the hbase row_key
> index which give you very quick nearly real-time response just like hbase
> does.
> From my test, query 1 doesn't seem fast at all, still taking ages, so
> select * from hive_hbase_test where key='blabla'   36secs
> vs
> get 'test', 'blabla'      less than 1 sec
> still shows a huge difference.
>
> Anybody has tried this before? Is there anyway I can do sort of query plan
> analysis against hive query? or I am not mapping hive table against hbase
> table correctly?

It doesn't work like that. Every Hive query is translated into a MR
job, so you're still doing a full scan to find that one row key.

J-D

Mime
View raw message