You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Lars Hofhansl (Jira)" <ji...@apache.org> on 2022/02/09 22:15:00 UTC
[jira] [Updated] (PHOENIX-6647) A local index should not be chosen for a full scan if that scan is not covered by the index.
[ https://issues.apache.org/jira/browse/PHOENIX-6647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Hofhansl updated PHOENIX-6647:
-----------------------------------
Description:
{code}
> explain select * from lineitem;
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
| PLAN | EST_BYTES_READ | EST |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
| CLIENT 103-CHUNK 17711182 ROWS 1059064693 BYTES PARALLEL 2-WAY ROUND ROBIN RANGE SCAN OVER LINEITEM [1] | 1059064693 | 177 |
| SERVER MERGE [0.PARTKEY, 0.SUPPKEY, 0.QUANTITY, 0.EXTENDEDPRICE, 0.DISCOUNT, 0.TAX, 0.RETURNFLAG, 0.LINESTATUS, 0.COMMITDATE, 0.RECEIPTDATE, 0.SHIPINSTRUCT, 0.SHIPMODE, 0.COMMENT] | 1059064693 | 177 |
| SERVER FILTER BY FIRST KEY ONLY | 1059064693 | 177 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
3 rows selected (0.056 seconds)
{code}
was:
> explain select * from lineitem;
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
| PLAN | EST_BYTES_READ | EST |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
| CLIENT 103-CHUNK 17711182 ROWS 1059064693 BYTES PARALLEL 2-WAY ROUND ROBIN RANGE SCAN OVER LINEITEM [1] | 1059064693 | 177 |
| SERVER MERGE [0.PARTKEY, 0.SUPPKEY, 0.QUANTITY, 0.EXTENDEDPRICE, 0.DISCOUNT, 0.TAX, 0.RETURNFLAG, 0.LINESTATUS, 0.COMMITDATE, 0.RECEIPTDATE, 0.SHIPINSTRUCT, 0.SHIPMODE, 0.COMMENT] | 1059064693 | 177 |
| SERVER FILTER BY FIRST KEY ONLY | 1059064693 | 177 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
3 rows selected (0.056 seconds)
> A local index should not be chosen for a full scan if that scan is not covered by the index.
> --------------------------------------------------------------------------------------------
>
> Key: PHOENIX-6647
> URL: https://issues.apache.org/jira/browse/PHOENIX-6647
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.1.2
> Reporter: Lars Hofhansl
> Priority: Major
>
> {code}
> > explain select * from lineitem;
> +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
> | PLAN | EST_BYTES_READ | EST |
> +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
> | CLIENT 103-CHUNK 17711182 ROWS 1059064693 BYTES PARALLEL 2-WAY ROUND ROBIN RANGE SCAN OVER LINEITEM [1] | 1059064693 | 177 |
> | SERVER MERGE [0.PARTKEY, 0.SUPPKEY, 0.QUANTITY, 0.EXTENDEDPRICE, 0.DISCOUNT, 0.TAX, 0.RETURNFLAG, 0.LINESTATUS, 0.COMMITDATE, 0.RECEIPTDATE, 0.SHIPINSTRUCT, 0.SHIPMODE, 0.COMMENT] | 1059064693 | 177 |
> | SERVER FILTER BY FIRST KEY ONLY | 1059064693 | 177 |
> +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
> 3 rows selected (0.056 seconds)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)