phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rajeshbabu@apache.org" <chrajeshbab...@gmail.com>
Subject Re: dropping Phoenix local index is not dropping the local index table in HBase
Date Thu, 30 Jun 2016 05:15:14 GMT
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.attluri@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
>

Mime
View raw message