[ https://issues.apache.org/jira/browse/PHOENIX-6088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Hofhansl updated PHOENIX-6088: ----------------------------------- Priority: Blocker (was: Major) > Local indexes are not updated in 5.1.x > -------------------------------------- > > Key: PHOENIX-6088 > URL: https://issues.apache.org/jira/browse/PHOENIX-6088 > Project: Phoenix > Issue Type: Bug > Reporter: Lars Hofhansl > Priority: Blocker > > {code:java} > > create table test(pk1 integer not null primary key, v1 float, v2 float); > No rows affected (0.658 seconds) > > create local index l2 on test(v2); > No rows affected (10.881 seconds) > > upsert into test values(rand()*10000, rand(), rand()); > 1 row affected (0.01 seconds) > 0: jdbc:phoenix:localhost> select count(*) from test; > +----------+ > | COUNT(1) | > +----------+ > | 0 | > +----------+ > > select /*+ NO_INDEX */ count(*) from test; > +----------+ > | COUNT(1) | > +----------+ > | 1 | > +----------+ > 1 row selected (0.018 seconds) > > select v2 from test; > +----+ > | V2 | > +----+ > +----+ > No rows selected (0.039 seconds) > > select /*+ NO_INDEX */ v2 from test; > +------------+ > | V2 | > +------------+ > | 0.57341254 | > +------------+ > 1 row selected (0.046 seconds) > > drop index l2 on test; > No rows affected (0.295 seconds) > > select v2 from test; > +------------+ > | V2 | > +------------+ > | 0.57341254 | > +------------+ > 1 row selected (0.032 seconds) > {code} > > This is bad. -- This message was sent by Atlassian Jira (v8.3.4#803005)