[ https://issues.apache.org/jira/browse/PHOENIX-4652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jepson updated PHOENIX-4652: ---------------------------- Description: 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/] was: *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/] > 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 > Priority: Major > Original Estimate: 504h > Remaining Estimate: 504h > > 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)