phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 沈宗强 (JIRA) <j...@apache.org>
Subject [jira] [Created] (PHOENIX-3753) The salt index affects the query plan of the non-salt table
Date Mon, 27 Mar 2017 06:37:41 GMT
沈宗强 created PHOENIX-3753:
----------------------------

             Summary: The salt index affects the query plan of the non-salt table
                 Key: PHOENIX-3753
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3753
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.9.0
            Reporter: 沈宗强


The salt index affects the query plan of the non-salt table,
Can be reproduced by the following example:
1.Create table:
CREATE TABLE IF NOT EXISTS test1 (
	date varchar NOT NULL,
 	cust_id INTEGER NOT NULL,
 	agent_id INTEGER,
 	pay BIGINT,
 	click BIGINT,
 	pv BIGINT,
 	CONSTRAINT pk PRIMARY KEY (date, cust_id)
);

2.Create index:
CREATE INDEX ix_test1 ON test1(agent_id) INCLUDE (pay, click) SALT_BUCKETS = 10;

3.Explain query:
EXPLAIN SELECT SUM(pay), SUM(click) FROM test1 WHERE DATE = '2017-01-01';

4.Expected result:
+---------------------------------------------------------------------+
|                                PLAN                                 |
+---------------------------------------------------------------------+
| CLIENT 1-CHUNK PARALLEL 1-WAY RANGE SCAN OVER TEST1 ['2017-01-01']  |
|     SERVER AGGREGATE INTO SINGLE ROW                                |
+---------------------------------------------------------------------+

5.Actual results:
+---------------------------------------------------------------------+
|                                PLAN                                 |
+---------------------------------------------------------------------+
| CLIENT 10-CHUNK PARALLEL 10-WAY RANGE SCAN OVER IX_TEST1 [0] - [9]  |
|     SERVER FILTER BY "DATE" = '2017-01-01'                          |
|     SERVER AGGREGATE INTO SINGLE ROW                                |
+---------------------------------------------------------------------+




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message