Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1171

Dropping the index is not verifying the associated table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 4.0.0
    • 3.1.0, 4.1.0
    • None
    • Linux HDP-2.1

    Description

      i had two tables,
      i created index on one table and dropped index by specifying other table,
      index was dropped succesfully, later when i tried indexing on the same table,
      it had thrown me error saying the index table name already exists,

      looks like, the reference was not updated in phoenix table,

      0: jdbc:phoenix:localhost:/hbase-unsecure> create table t1( id integer not null primary key ,name char(5));
      No rows affected (17.666 seconds)
      0: jdbc:phoenix:localhost:/hbase-unsecure> create table t2( id integer not null primary key ,name char(5));
      No rows affected (1.296 seconds)
      0: jdbc:phoenix:localhost:/hbase-unsecure> CREATE INDEX i1 ON t1 (id);
      No rows affected (3.164 seconds)
      0: jdbc:phoenix:localhost:/hbase-unsecure> DROP INDEX i1 on t2;
      No rows affected (2.023 seconds)

      Attachments

        1. PHOENIX-1171.patch
          11 kB
          James R. Taylor
        2. PHOENIX-1171-addendum.patch
          4 kB
          James R. Taylor

        Activity

          People

            jamestaylor James R. Taylor
            yeshwanth43 yeshwanth
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 72h
                72h
                Remaining:
                Remaining Estimate - 72h
                72h
                Logged:
                Time Spent - Not Specified
                Not Specified