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)