phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jepson (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-4652) When column is existed index table,drop the column,the index table is dropped.
Date Tue, 13 Mar 2018 05:33:00 GMT

     [ 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)

Mime
View raw message