phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Gupta <abhila...@gmail.com>
Subject RVC query's explain plan shows full scan
Date Wed, 20 Jun 2018 05:55:08 GMT
Hi,

I am trying to use RVC query for pagination on phoenix but in the explain
plan it always shows the plan as 'FULL SCAN' instead of 'RANGE SCAN'. This
is happening for all the versions of phoenix from 4.7.+ to 4.14 (latest).

Following is an example

0: jdbc:phoenix:localhost> explain select domain, sum(issue_assign_count)
from support_metrics where (domain,truncated_time) >=
('test','201801010030') group by domain limit 10;

*+------------------------------------------------------------------------------+-----------------+----------------+--------------+*

*| **                                    PLAN
     ** | **EST_BYTES_READ ** | **EST_ROWS_READ ** | **EST_INFO_TS ** |*

*+------------------------------------------------------------------------------+-----------------+----------------+--------------+*

*| *CLIENT 1-CHUNK PARALLEL 1-WAY FULL SCAN OVER SUPPORT_METRICS
     * | *null           * | *null          * | *null        * |*

*| *    SERVER AGGREGATE INTO ORDERED DISTINCT ROWS BY [DOMAIN] LIMIT 10
GROUPS * | *null           * | *null          * | *null        * |*

*| *CLIENT 10 ROW LIMIT
     * | *null           * | *null          * | *null        * |*

*+------------------------------------------------------------------------------+-----------------+----------------+--------------+*

3 rows selected (0.025 seconds)

0: jdbc:phoenix:localhost> explain select domain, sum(issue_assign_count)
from support_metrics where domain = 'test' and truncated_time >=
'201801010030' group by domain limit 10;

*+-----------------------------------------------------------------------------------------------------+-----------------+----------------+--------------+*

*| **                                               PLAN
                             ** | **EST_BYTES_READ ** | **EST_ROWS_READ **
| **EST_INFO_TS ** |*

*+-----------------------------------------------------------------------------------------------------+-----------------+----------------+--------------+*

*| *CLIENT 1-CHUNK PARALLEL 1-WAY RANGE SCAN OVER SUPPORT_METRICS
['test','201801010030'] - ['test',*] * | *null           * | *null          *
| *null        * |*

*| *    SERVER AGGREGATE INTO ORDERED DISTINCT ROWS BY [DOMAIN] LIMIT 10
GROUPS                        * | *null           * | *null          * | *null
       * |*

*| *CLIENT 10 ROW LIMIT
                           * | *null           * | *null          * | *null
     * |*

*+-----------------------------------------------------------------------------------------------------+-----------------+----------------+--------------+*

Would appreciate any help on this issue.


Thanks,

Abhishek

Mime
View raw message