[
https://issues.apache.org/jira/browse/PHOENIX-6264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17250208#comment-17250208
]
taile edited comment on PHOENIX-6264 at 12/16/20, 9:37 AM:
-----------------------------------------------------------
create table
CREATE TABLE FN1.CHATDOC (CREATE TABLE FN1.CHATDOC ( ID UNSIGNED_LONG NOT NULL,
PARENTID UNSIGNED_LONG, TITLE VARCHAR(2000), LINKURL VARCHAR(2000), DOCCREATOR
VARCHAR(100), CONSTRAINT CHATDOC_PK PRIMARY KEY (ID));
create index
CREATE INDEX IDX_CHATDOC_INCLUD ON FN1.CHATDOC(PARENTID)
INCLUDE(TITLE,LINKURL,DOCCREATOR) COMPRESSION = 'GZ', SALT_BUCKETS = 2;
delete index
DROP INDEX IDX_CHATDOC_INCLUD ON FN1.CHATDOC;
was (Author: taile):
CREATE TABLE FN1.CHATDOC (CREATE TABLE FN1.CHATDOC ( ID UNSIGNED_LONG NOT NULL,
PARENTID UNSIGNED_LONG, TITLE VARCHAR(2000), LINKURL VARCHAR(2000), DOCCREATOR
VARCHAR(100), CONSTRAINT CHATDOC_PK PRIMARY KEY (ID));
> phoenix table is not queryable after dropping the secondary index
> -----------------------------------------------------------------
>
> Key: PHOENIX-6264
> URL: https://issues.apache.org/jira/browse/PHOENIX-6264
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.0.0
> Reporter: taile
> Priority: Major
> Attachments: image-2020-12-14-12-11-18-828.png,
> image-2020-12-14-12-12-22-575.png, image-2020-12-14-12-13-45-640.png
>
>
> The phoenix table is not queryable after dropping the secondary index. The
> !table command shows the table, and accessing data from HBase has no issue.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
