phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vamsi Krishna <vamsi.attl...@gmail.com>
Subject Re: dropping Phoenix local index is not dropping the local index table in HBase
Date Thu, 30 Jun 2016 06:20:57 GMT
Thanks Rajeshbabu.

On Wed, Jun 29, 2016 at 10:15 PM rajeshbabu@apache.org <
chrajeshbabu32@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.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
>>
>
> --
Vamsi Attluri

Mime
View raw message