You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Jepson (JIRA)" <ji...@apache.org> on 2018/03/13 05:32:00 UTC
[jira] [Created] (PHOENIX-4652) When column is existed index
table,drop the column,the index table is dropped.
Jepson created PHOENIX-4652:
-------------------------------
Summary: When column is existed index table,drop the column,the index table is dropped.
Key: PHOENIX-4652
URL: https://issues.apache.org/jira/browse/PHOENIX-4652
Project: Phoenix
Issue Type: Wish
Affects Versions: 4.10.0
Reporter: Jepson
*1.*When column is existed index table,drop the column,the index table is dropped.
I hope that the column with index table is dropped,not the index table.
{code:java}
CREATE TABLE JYDW.TEST(
ID INTEGER primary key,
NAME VARCHAR(128),
AGE INTEGER,
CREDATE DATE,
CRETIME TIMESTAMP
)SALT_BUCKETS = 12, COMPRESSION='SNAPPY';
CREATE INDEX TEST_IDX ON
JYDW.TEST(
NAME,
AGE
);
alter table JYDW.TEST drop column name;
alter table JYDW.TEST add name varchar(256);
{code}
*when drop the name column, the TEST_IDX index table will be dropped.*
*2.*Phoenix log:
18/03/13 10:44:51 INFO client.HBaseAdmin: Started disable of JYDW:TEST_IDX
18/03/13 10:44:54 INFO client.HBaseAdmin: Disabled JYDW:TEST_IDX
18/03/13 10:45:42 INFO client.HBaseAdmin: Deleted JYDW:TEST_IDX
18/03/13 10:46:03 INFO ConnectionPool.RawMaxwellConnectionPool: RawMaxwellConnectionPool: Destroyed connection
*3.*I want modify the name column, but the modify sql syntax isn't supported,
so drop first ,then add.
*4.*Reference:
[https://issues.apache.org/jira/browse/PHOENIX-4651|http://example.com/]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)