phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Geoffrey Jacoby (Jira)" <j...@apache.org>
Subject [jira] [Assigned] (PHOENIX-5453) incorrect metadata caused by `CREATE INDEX`
Date Mon, 09 Sep 2019 18:45:00 GMT

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

Geoffrey Jacoby reassigned PHOENIX-5453:
----------------------------------------

    Assignee: Geoffrey Jacoby

> incorrect metadata caused by `CREATE INDEX`  
> ---------------------------------------------
>
>                 Key: PHOENIX-5453
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5453
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Xinyi Yan
>            Assignee: Geoffrey Jacoby
>            Priority: Major
>
>  
> {code:java}
> CREATE TABLE BASETABLE (A BIGINT PRIMARY KEY, B BIGINT, C BIGINT);
> 0: jdbc:phoenix:> UPSERT INTO BASETABLE VALUES(1,1,1);
> 1 row affected (0.092 seconds)
> 0: jdbc:phoenix:> UPSERT INTO BASETABLE VALUES(2,2,2);
> 1 row affected (0.006 seconds)
> 0: jdbc:phoenix:> UPSERT INTO BASETABLE VALUES(3,3,3);
> 1 row affected (0.006 seconds)
> 0: jdbc:phoenix:> CREATE VIEW VIEW_TEST AS SELECT * FROM BASETABLE WHERE A > 1;
> No rows affected (0.141 seconds)
> 0: jdbc:phoenix:> CREATE INDEX INDEX_TESTING ON VIEW_TEST(B) INCLUDE(C);
> 2 rows affected (5.992 seconds)
> 0: jdbc:phoenix:> SELECT * FROM INDEX_TESTING;
> +------+----------------------+-----+
> | 0:B  |          :A          | 0:C |
> +------+----------------------+-----+
> | null | -9223372036842126592 | 2   |
> | null | -9223372036842126336 | 3   |
> +------+----------------------+-----+
> 2 rows selected (0.072 seconds)
> {code}
>  
> While I was testing one of the Jiras on the master branch, I found this `CREATE INDEX`
issue on the master branch.
> Local env:
> Hadoop 2.7.7
> HBase 2.0
> Phoenix built from the master branch.



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

Mime
View raw message