Re: Cant run map-reduce index builder because my view/idx is lower case

[Batyrshin Alexander]

Hello again,

Could you, please, help me to run map-reduce for indexing view with lower-case 
name?

Here is my test try on Phoenix-4.8.2:

CREATE TABLE "table" (
    c1 varchar,
    c2 varchar,
    c3 varchar
    CONSTRAINT pk PRIMARY KEY (c1,c2,c3)
)

CREATE VIEW "table_view"
AS SELECT * FROM "table" WHERE c3 = 'X';

CREATE INDEX "table_view_idx" ON "table_view" (c2, c1) ASYNC;

sudo -u hadoop ./bin/hbase org.apache.phoenix.mapreduce.index.IndexTool 
--data-table '"table_view"' --index-table '"table_view_idx"' --output-path 
ASYNC_IDX_HFILES

2017-06-19 21:27:17,716 ERROR [main] index.IndexTool: An exception occurred 
while performing the indexing job: IllegalArgumentException:  TABLE_VIEW_IDX is 
not an index table for TABLE_VIEW  at:
java.lang.IllegalArgumentException:  TABLE_VIEW_IDX is not an index table for 
TABLE_VIEW
        at org.apache.phoenix.mapreduce.index.IndexTool.run(IndexTool.java:190)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84)
        at org.apache.phoenix.mapreduce.index.IndexTool.main(IndexTool.java:394)


> On 17 Jun 2017, at 03:55, Batyrshin Alexander <0x62...@gmail.com> wrote:
> 
>  Hello,
> Im trying to build ASYNC index by example from 
> https://phoenix.apache.org/secondary_indexing.html 
> <https://phoenix.apache.org/secondary_indexing.html>
> My issues is that my view name and index name is lower case, so map-reduce 
> rise error:
> 
> 2017-06-17 03:45:56,506 ERROR [main] index.IndexTool: An exception occurred 
> while performing the indexing job: IllegalArgumentException:  
> INVOICES_V4_INDEXED_FUZZY_IDX is not an index table for 
> INVOICES_V4_INDEXED_FUZZY
>