You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by tj...@gmail.com on 2013/08/14 04:40:13 UTC
some problems about Hive HBaseIntegration
Hi Devs/Users;
I read the document about HBaseIntegration in hive , and I did a test for
this .
the same data stored in hdfs and hbase , I create two external tables and
use the same hiveQL to query ;
The result is that querying from hdfs external table costs about 20 mins ,
querying from hbase external table costs greater than 3 hours .
Can someone tell me why it happens , is it possible optimized ?
Re: some problems about Hive HBaseIntegration
Posted by Bharath Vissapragada <bh...@cloudera.com>.
Increase hbase.client.scanner.caching! It helps
On Wed, Aug 14, 2013 at 8:10 AM, <tj...@gmail.com> wrote:
> Hi Devs/Users;
>
>
>
> I read the document about HBaseIntegration in hive , and I did a test for
> this .
>
>
>
> the same data stored in hdfs and hbase , I create two external tables and
> use the same hiveQL to query ;
>
>
>
> The result is that querying from hdfs external table costs about 20 mins ,
> querying from hbase external table costs greater than 3 hours .
>
>
>
> Can someone tell me why it happens , is it possible optimized ?
>
>
--
Bharath Vissapragada
<http://www.cloudera.com>