Since we are storing all local indexes data in a single shared table that's why we are not dropping when we drop a local index. We can check for any local indexes or not and then we can drop it.
Now as part of PHOENIX-1734 we have reimplemented local indexes and storing local indexes also in same data table. Thanks, Rajeshbabu. On Tue, Jun 28, 2016 at 4:45 PM, Vamsi Krishna <vamsi.attl...@gmail.com> wrote: > Team, > > I'm using HDP 2.3.2 (HBase : 1.1.2, Phoenix : 4.4.0). > *Question: *Dropping Phoenix local index is not dropping the local index > table in HBase. Can someone explain why? > > Phoenix: > CREATE TABLE IF NOT EXISTS VAMSI.TABLE_B (COL1 VARCHAR(36) , COL2 > VARCHAR(36) , COL3 VARCHAR(36) CONSTRAINT TABLE_B_PK PRIMARY KEY (COL1)) > COMPRESSION='SNAPPY', SALT_BUCKETS=5; > CREATE LOCAL INDEX IF NOT EXISTS IDX_TABLE_A_COL2 ON VAMSI.TABLE_A (COL2); > DROP INDEX IF EXISTS IDX_TABLE_A_COL2 ON VAMSI.TABLE_A; > > hbase(main):012:0> list '_LOCAL.*' > TABLE > _LOCAL_IDX_VAMSI.TABLE_A > > Thanks, > Vamsi Attluri > -- > Vamsi Attluri >
