phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ethan Wang (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-3954) Message displayed during "Alter view" is not accurate
Date Fri, 16 Jun 2017 22:14:00 GMT

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

Mime
View raw message