[
https://issues.apache.org/jira/browse/PHOENIX-3954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ethan Wang updated PHOENIX-3954:
--------------------------------
Summary: Message displayed during "Alter view" is not accurate (was:
Message displayed during "Alter view" is not correct )
> Message displayed during "Alter view" is not accurate
> ------------------------------------------------------
>
> 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)
