phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Decaux <ebui...@gmail.com>
Subject Re: Trying to reduce read latency for full table scan
Date Thu, 07 Jan 2016 17:20:35 GMT
Can you update Phoenix to la test version?

1s is really slow, could be  network or client issue ?

Did  you try apache drill to compare ?
Le 7 janv. 2016 2:50 PM, "Sreeram" <sreeram.v@gmail.com> a écrit :

> Hi,
>
>  I am new to Phoenix & I am trying to perform basic full table select from
> a table.
>
>  I am connecting using JDBC and I am seeing that a full table scan for
> 1000 records (14 columns, approx 150 bytes per record) is alwasy taking
> more than a second. Scan from Hbase on equivalent HBase table takes close
> to 170 ms on average. The HBase table has a composite row key & the same
> columns are provided as part of PRIMARY KEY CONSTRAINT in the Phoenix table.
>
>  I use a two node cluster & have specified SALT_BUCKETS=2 as part of table
> creation.
>
>  I am using Phoenix version 4.3 and Hbase version 1.0.0
>
>  I think I am missing something basic here - will appreciate any inputs on
> how I can reduce the Phoenix read latency.
>
>  Regards,
>  Sreeram
>

Mime
View raw message