Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. 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)

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 4.8.1
    • Labels:
      None

      Description

      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)

        Attachments

        1. image1.png
          246 kB
          Kalyan
        2. image2.png
          127 kB
          Kalyan
        3. image3.png
          261 kB
          Kalyan
        4. phoenix_duplicate_column_check.patch
          4 kB
          Kalyan

          Activity

            People

            • Assignee:
              kalyanhadoop Kalyan
              Reporter:
              kalyanhadoop Kalyan
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: