Thanks Rajeshbabu. On Wed, Jun 29, 2016 at 10:15 PM rajeshb...@apache.org < chrajeshbab...@gmail.com> wrote:
> 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 >> > > -- Vamsi Attluri
