phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chinmay Kulkarni (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4743) ALTER TABLE ADD COLUMN for global index should not modify HBase metadata if failed
Date Fri, 18 May 2018 02:09:00 GMT
Chinmay Kulkarni created PHOENIX-4743:
-----------------------------------------

             Summary: ALTER TABLE ADD COLUMN for global index should not modify HBase metadata
if failed
                 Key: PHOENIX-4743
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4743
             Project: Phoenix
          Issue Type: Bug
            Reporter: Chinmay Kulkarni


When you issue an "ALTER TABLE" for a global index to add a column, Phoenix throws a SQLException,
but the HBase metadata for the global index table is still modified.

Steps to reproduce:
 # Create the base data table: 

{code:java}
create table if not exists z_base_table (id INTEGER not null primary key, host VARCHAR(10),
flag boolean);{code}

 # Create a global index on top of this table:
{code:java}
create index global_z_index on z_base_table(HOST);{code}

 # Alter the global index table to add a column:
{code:java}
alter table global_z_index add cf1.age INTEGER;{code}

This will throw an exception in Phoenix, but HBase metadata for the global index table is
still modified. Stack trace:

 
{noformat}
Error: ERROR 1010 (42M01): Not allowed to mutate table. Cannot add/drop column referenced
by VIEW columnName=GLOBAL_Z_INDEX (state=42M01,code=1010)
 java.sql.SQLException: ERROR 1010 (42M01): Not allowed to mutate table. Cannot add/drop column
referenced by VIEW columnName=GLOBAL_Z_INDEX
 at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:494)
 at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)
 at org.apache.phoenix.schema.MetaDataClient.processMutationResult(MetaDataClient.java:3049)
 at org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:3503)
 at org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:3210)
 at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAddColumnStatement$1.execute(PhoenixStatement.java:1432)
 at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:408)
 at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391)
 at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
 at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390)
 at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378)
 at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1825)
 at sqlline.Commands.execute(Commands.java:822)
 at sqlline.Commands.sql(Commands.java:732)
 at sqlline.SqlLine.dispatch(SqlLine.java:813)
 at sqlline.SqlLine.begin(SqlLine.java:686)
 at sqlline.SqlLine.start(SqlLine.java:398)
 at sqlline.SqlLine.main(SqlLine.java:291{noformat}
 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message