Hi James, https://issues.apache.org/jira/browse/PHOENIX-2319
Thanks, Chunhui Liu 2015-10-14 14:07 GMT+08:00 James Taylor <[email protected]>: > Hi Chunhui, > This sounds like a bug. What version of Phoenix are you using? Please file > a JIRA and if you could include a simple unit test that demonstrates the > issue, that would be much appreciated. > Thanks, > James > > On Tue, Oct 13, 2015 at 11:04 PM, Chunhui Liu <[email protected]> wrote: > >> Hi Team, >> >> Recently, When I try to learn paged query on table with secondary index, >> I got this. >> >> 1. create a table, and use all columns(eg. pk1, pk2) as constraint pk; >> 2. create a secondary index on the table, use (pk2, pk1) as constraint pk; >> 3. create some test data; >> 4. select pk1, pk2 from t where pk2='202'; >> 5. no result; >> >> Test on >> phoenix4.5.2-hbase-0.98, cdh 5.3.6 >> >> ----------------------------------------------------------------- >> >> --Create table, all columns are primary key. >> CREATE TABLE IF NOT EXISTS T ( >> PK1 VARCHAR not null, >> PK2 VARCHAR not null, >> CONSTRAINT PK PRIMARY KEY (PK1, PK2) >> ); >> >> --Create secondary index >> CREATE INDEX IDX_T ON T >> ( >> PK2, PK1 >> ); >> >> --Test data >> UPSERT INTO T VALUES('100', '200'); >> UPSERT INTO T VALUES('101', '201'); >> UPSERT INTO T VALUES('102', '202'); >> UPSERT INTO T VALUES('103', '203'); >> UPSERT INTO T VALUES('104', '204'); >> >> --make sure data was created correctly. >> SELECT * FROM T; >> >> --success >> SELECT PK1, PK2 FROM T WHERE PK1='102'; >> >> --*no result* with conditions(pk2[=,>,<,>=,<=]'202') >> EXPLAIN >> SELECT PK1, PK2 FROM T WHERE PK2 = '202'; >> >> --success >> EXPLAIN >> SELECT /*+ NO_INDEX*/ PK1, PK2 FROM T WHERE PK2 = '202'; >> >> --cleanup >> DROP TABLE IF EXISTS T; >> >> ----------------------------------------------------------------- >> >> *Then*, I create a table with extra column(KV), SELECT is ok. >> >> ----------------------------------------------------------------- >> CREATE TABLE IF NOT EXISTS T ( >> PK1 VARCHAR not null, >> PK2 VARCHAR not null, >> KV VARCHAR, >> CONSTRAINT PK PRIMARY KEY (PK1, PK2) >> ); >> >> --Create secondary index >> CREATE INDEX IDX_T ON T >> ( >> PK2, PK1 >> ); >> ----------------------------------------------------------------- >> >> Is this a bug? >> >> Chunhui, >> Thanks. >> > >
