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 <vamsi.attl...@gmail.com> 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 >
