[jira] [Created] (PHOENIX-3185) Error: ERROR 514 (42892): A duplicate column name was detected in the object definition or ALTER TABLE statement. columnName=TEST_TABLE.C1 (state=42892,code=514)

["Kalyan (JIRA)" <ji...@apache.org>]

Kalyan created PHOENIX-3185:
-------------------------------

             Summary: Error: ERROR 514 (42892): A duplicate column name was detected in the object definition or ALTER TABLE statement. columnName=TEST_TABLE.C1 (state=42892,code=514)
                 Key: PHOENIX-3185
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3185
             Project: Phoenix
          Issue Type: Bug
            Reporter: Kalyan
            Assignee: Kalyan


create a table with duplicate columns.

create table test_table (rowkey varchar primary key, c1 varchar, c2 integer, c3 double, c1 bigint);

The below exception getting .. no issue with exception. But the problem is phoenix is creating table with exception & later we are not able to delete the table also. We need to fix this Bug

0: jdbc:phoenix:localhost> create table test_table (rowkey varchar primary key, c1 varchar, c2 integer, c3 double, c1 bigint);
Error: ERROR 514 (42892): A duplicate column name was detected in the object definition or ALTER TABLE statement. columnName=TEST_TABLE.C1 (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=TEST_TABLE.C1
	at org.apache.phoenix.schema.PTableImpl.init(PTableImpl.java:415)
	at org.apache.phoenix.schema.PTableImpl.<init>(PTableImpl.java:315)
	at org.apache.phoenix.schema.PTableImpl.makePTable(PTableImpl.java:288)
	at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2146)
	at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:828)
	at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:338)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:326)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:324)
	at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1345)
	at sqlline.Commands.execute(Commands.java:822)
	at sqlline.Commands.sql(Commands.java:732)
	at sqlline.SqlLine.dispatch(SqlLine.java:808)
	at sqlline.SqlLine.begin(SqlLine.java:681)
	at sqlline.SqlLine.start(SqlLine.java:398)
	at sqlline.SqlLine.main(SqlLine.java:292)




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)