phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "xufeng (JIRA)" <j...@apache.org>
Subject [jira] [Issue Comment Deleted] (PHOENIX-1436) the choice of index by phoneix is not correct where do querying
Date Wed, 12 Nov 2014 07:48:33 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-1436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

xufeng updated PHOENIX-1436:
----------------------------
    Comment: was deleted

(was: there are other one issue in my env.
phoenix4.1
hbase0.98.6
hadoop1.2.1

1.create a table.
2.upsert some data.
3.delete from this table.
4.upsert some data.
5.select * from this table.
result:no data be selected! and one data be scan in hbase shell.


should I create other issue to track it??)

> 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
>
> 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