You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Ethan Wang (JIRA)" <ji...@apache.org> on 2017/06/16 22:14:00 UTC

[jira] [Updated] (PHOENIX-3954) Message displayed during "Alter view" is not accurate

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