[
https://issues.apache.org/jira/browse/PHOENIX-4652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16723228#comment-16723228
]
Swaroopa Kadam edited comment on PHOENIX-4652 at 12/17/18 6:03 PM:
-------------------------------------------------------------------
[[email protected]] What is the behavior that is expected from this 'wish'? To
drop the column from index or drop the complete index? am I missing something?
was (Author: swaroopa):
[[email protected]] What is the behavior that is expected from this 'wish'? To
drop the column from index or drop the complete index?
> 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)
