[jira] [Created] (PHOENIX-2724) Query with large number of guideposts is slower compared to no stats

["Mujtaba Chohan (JIRA)" <ji...@apache.org>]

Mujtaba Chohan created PHOENIX-2724:
---------------------------------------

             Summary: Query with large number of guideposts is slower compared to no stats
                 Key: PHOENIX-2724
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2724
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.7.0
         Environment: Phoenix 4.7.0-RC4, HBase-0.98.17 on a 8 node cluster
            Reporter: Mujtaba Chohan


With 1MB guidepost width for ~900GB/500M rows table. Queries with short scan range gets significantly slower.

Without stats:
{code}
select * from T limit 10; // query execution time <100 msec
{code}

With stats:
{code}
select * from T limit 10; // query execution time >20 seconds

Explain plan: CLIENT 876085-CHUNK 476569382 ROWS 876060986727 BYTES SERIAL 1-WAY FULL SCAN OVER T SERVER 10 ROW LIMIT CLIENT 10 ROW LIMIT
{code}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)