Thanks Ankit. On Wed, Jun 29, 2016 at 12:11 PM Ankit Singhal <[email protected]> wrote:
> Hi Vamsi, > > Phoenix uses single local Index table for all the local indexes created on > a particular data table. > Rows are differentiated by local index sequence id and filtered when > requested during the query for particular index. > > Regards, > Ankit Singhal > > Re > > On Tue, Jun 28, 2016 at 4:18 AM, Vamsi Krishna <[email protected]> > wrote: > >> Team, >> >> I'm using HDP 2.3.2 (HBase : 1.1.2, Phoenix : 4.4.0). >> *Question:* For multiple local indexes on Phoenix table only one local >> index table is being created in HBase. Is this regular behavior? 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); >> CREATE LOCAL INDEX IF NOT EXISTS IDX_TABLE_A_COL3 ON VAMSI.TABLE_A (COL3); >> >> hbase(main):012:0> list '_LOCAL.*' >> TABLE >> _LOCAL_IDX_VAMSI.TABLE_A >> >> Thanks, >> Vamsi Attluri >> -- >> Vamsi Attluri >> > > -- Vamsi Attluri
