You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Vamsi Krishna <va...@gmail.com> on 2016/06/28 11:15:52 UTC
dropping Phoenix local index is not dropping the local index table in HBase
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
Re: dropping Phoenix local index is not dropping the local index
table in HBase
Posted by Vamsi Krishna <va...@gmail.com>.
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 <va...@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
Re: dropping Phoenix local index is not dropping the local index
table in HBase
Posted by "rajeshbabu@apache.org" <ch...@gmail.com>.
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 <va...@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
>