You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Lars Hofhansl (Jira)" <ji...@apache.org> on 2020/08/20 01:03:00 UTC
[jira] [Comment Edited] (PHOENIX-6088) Local indexes are not
updated in 5.1.x
[ https://issues.apache.org/jira/browse/PHOENIX-6088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17180896#comment-17180896 ]
Lars Hofhansl edited comment on PHOENIX-6088 at 8/20/20, 1:02 AM:
------------------------------------------------------------------
Not sure how this got through tests. (Or maybe it depends on specific versions of HBase/Hadoop).
My phoenix is built again HBase 2.2.5, but the HBase running is 2.4.0-SNAPSHOT, but that absolutely should work!
was (Author: lhofhansl):
Not sure how this got through tests. (Or maybe it depends on specific versions of HBase/Hadoop)
> 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)