phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fawaz Enaya <m.fawaz.en...@gmail.com>
Subject Phoenix Slow Problem
Date Sun, 30 Oct 2016 11:42:21 GMT
Hi All in this great project,


I have an HBase cluster of four nodes, I use Phoenix to access HBase, but I
do not know why its too much slow to execute SELECT count(*) for table
contains 5 million records it takes 8 seconds.
Below is the explain for may select statement

CLIENT 6-CHUNK 9531695 ROWS 629145639 BYTES PARALLEL 1-WAY FULL SCAN OVER
TABLE* |*

*| *    SERVER FILTER BY FIRST KEY ONLY
     * |*

*| *    SERVER AGGREGATE INTO SINGLE ROW
Anyone can help.

Many Thanks
--
Thanks & regards,

Mime
View raw message