phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anil gupta <anilgupt...@gmail.com>
Subject Re: Optimized way to retrieve the large dataset from phoenix
Date Fri, 13 Apr 2018 05:43:35 GMT
Hi,

This benchmark study might help you:
https://hortonworks.com/blog/hbase-cassandra-benchmark/
However, YMMV as per your workload, cluster tuning and node types.
If you are doing random point lookups(using exact rowkey/primary key) then
i think you can probably try using
https://phoenix.apache.org/language/index.html#small_hint

~Anil Gupta

On Thu, Apr 12, 2018 at 2:29 PM, Sawant, Chandramohan <
chandramohan.sawant@citi.com.invalid> wrote:

> Hi All,
>
> Is there any optimized way to retrieve the larger dataset of ~1 million
> rows (1 row = 200 bytes of data) from HBase via Phoenix jdbc driver.
> In my application we are using Phoenix 4.8 with HBase 1.2 and getting
> slower performance while fetching the data through sql query.
> We have a 5 node cluster with 5 region servers respectively.
>
> Do let us know if you have encounter this situation and what is the
> suggestion we should implement it to make it faster.
>
>
> Regards,
> CM
> +1 201 763 1656
>
>


-- 
Thanks & Regards,
Anil Gupta

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message