phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-1436) the choice of index by phoneix is not correct where do querying
Date Sat, 22 Nov 2014 05:53:34 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-1436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14221828#comment-14221828
] 

Hudson commented on PHOENIX-1436:
---------------------------------

SUCCESS: Integrated in Phoenix-3.0-hadoop1 #320 (See [https://builds.apache.org/job/Phoenix-3.0-hadoop1/320/])
PHOENIX-1436 the choice of index by phoneix is not correct where do querying (jtaylor: rev
bd849e33800070c1de9dc5ca206bcbfa04193482)
* phoenix-core/src/test/java/org/apache/phoenix/compile/QueryOptimizerTest.java


> the choice of index by phoneix is not correct where do querying
> ---------------------------------------------------------------
>
>                 Key: PHOENIX-1436
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1436
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.1
>         Environment: phoenix4.1
> HBase 0.98.6
> hadoop 1.2.1
>            Reporter: xufeng
>            Assignee: rajeshbabu
>             Fix For: 5.0.0, 4.3, 3.3, 3.2.2, 4.2.2
>
>         Attachments: PHOENIX-1436.patch, PHOENIX-1436_v2.patch
>
>
> 1.create INDEX_TEST_TABLE:
> create table index_test_table (a varchar not null,b varchar not null,c varchar not null,d
varchar,e varchar, f varchar constraint pk primary key(a,b,c));
> 2.upsert some data into table.
> 3.create index on 'D' and 'F'
>  create index INDEX_TEST_TABLE_INDEX_D on INDEX_TEST_TABLE(A,D) include(B,C,E,F);
>  5 rows affected (0.747 seconds) 
> 0: jdbc:phoenix:10.20.14.35:2181> create index INDEX_TEST_TABLE_INDEX_F on INDEX_TEST_TABLE(A,F)
include(B,C,D,E); 
> 5 rows affected (0.748 seconds)
> 4.query data on 'D'
> explain select * from INDEX_TEST_TABLE where A in ('1','2','3','4','5') and D in ('1111','2222','3333');
> 5. it is ok:
> CLIENT PARALLEL 1-WAY SKIP SCAN ON 15 KEYS OVER INDEX_TEST_TABLE_INDEX_D ['1','1111']
- ['5','3333']
> 6. but query data on 'F'
> explain select * from INDEX_TEST_TABLE where A in ('1','2','3','4','5') and F in ('1111','2222','3333');
> 7. also use the index on 'D' and set filter on 'F'
> CLIENT PARALLEL 1-WAY SKIP SCAN ON 5 KEYS OVER INDEX_TEST_TABLE_INDEX_D ['1'] - ['5']
|
> SERVER FILTER BY F IN ('1111','2222','3333') |
> is this a bug in 4.1 version??



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

Mime
View raw message