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
