Ethan Wang created PHOENIX-3954:
-----------------------------------

             Summary: Message displayed during "Alter view" is not correct 
                 Key: PHOENIX-3954
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3954
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.8.0
         Environment: MacOS. Phoenix 4.8. Java 1.8
            Reporter: Ethan Wang
            Priority: Minor


When "Alter view" command failed, the error message refer view as "TABLE." 
example below:

ALTER VIEW V_T000002 ADD k3 VARCHAR PRIMARY KEY, k2 VARCHAR PRIMARY KEY, v2 
INTEGER;


Error: ERROR 514 (42892): A duplicate column name was detected in the object 
definition or ALTER TABLE statement. columnName=V_T000002.K2 
(state=42892,code=514)
org.apache.phoenix.schema.ColumnAlreadyExistsException: ERROR 514 (42892): A 
duplicate column name was detected in the object definition or ALTER TABLE 
statement. columnName=V_T000002.K2
        at 
org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:3557)
        at 
org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:3124)
        at 
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAddColumnStatement$1.execute(PhoenixStatement.java:1342)
        at 
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:393)
        at 
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:376)
        at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
        at 
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:375)
        at 
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:363)
        at 
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1707)
        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)




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to