[
https://issues.apache.org/jira/browse/PHOENIX-3185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15424873#comment-15424873
]
James Taylor edited comment on PHOENIX-3185 at 8/17/16 4:44 PM:
----------------------------------------------------------------
Agree, [~kalyanhadoop], it's an important fix. Not worried about code format
yet. I'd just like to get a test run across all tests to make sure your change
doesn't introduce any regressions. That'll happen if you attach a patch like
this as described in the link I mentioned:
{code}
git format-patch --stdout origin > PHOENIX-{NUMBER}.patch
{code}
was (Author: jamestaylor):
Agree, [~kalyanhadoop], it's an important fix. Not worried about code format
yet. I'd just like to get a test run across all tests to make sure your change
doesn't introduce any regressions. That'll happen if you attach a patch like
this as described in the link I mentioned: {{git format-patch --stdout origin >
PHOENIX-{NUMBER}.patch}}
> 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
> Fix For: 4.8.1
>
> Attachments: image1.png, image2.png, image3.png,
> phoenix_duplicate_column_check.patch
>
>
> 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)
