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/30 07:41:30 UTC

Exception when trying to build Local Index asynchronously

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