Team, I'm using HDP 2.3.2 (HBase 1.1.2, Phoenix 4.4.0) I'm seeing an exception when I run the IndexTool MapReduce job to build Local Index asynchronously. Could someone please help me understand what I'm doing wrong?
*Create Table:* CREATE TABLE IF NOT EXISTS VAMSI.TABLE_A (COL1 VARCHAR(36) , COL2 VARCHAR(36) , COL3 VARCHAR(36) CONSTRAINT TABLE_A_PK PRIMARY KEY (COL1)) COMPRESSION='SNAPPY', SALT_BUCKETS=5; *Create Index:* CREATE LOCAL INDEX IF NOT EXISTS IDX_TABLE_A_COL2 ON VAMSI.TABLE_A (COL2) ASYNC; After I create the Local Index with 'ASYNC' option and list the tables in Phoenix I see the index created and is in 'BUILDING' state. *Build Index data:* hbase org.apache.phoenix.mapreduce.index.IndexTool --schema VAMSI --data-table TABLE_A --index-table IDX_TABLE_A_COL2 --output-path hdfs://xxxxxx/user/user123/test/indexdata *ERROR:* 2016-06-30 03:11:13,875 ERROR [main] index.IndexTool: An exception occured while performing the indexing job , error message VAMSI.IDX_TABLE_A_COL2 is not an index table for VAMSI.TABLE_A Thanks, Vamsi Attluri -- Vamsi Attluri
