phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Batyrshin Alexander <0x62...@gmail.com>
Subject Re: Cant run map-reduce index builder because my view/idx is lower case
Date Thu, 22 Jun 2017 22:46:06 GMT
 Great, i will try.
> On 23 Jun 2017, at 00:24, Sergey Soldatov <sergeysoldatov@gmail.com> wrote:
> 
> You may try to build Phoenix with patch from  PHOENIX-3710 <https://issues.apache.org/jira/browse/PHOENIX-3710>
applied.That should fix the problem, I believe. 
> Thanks,
> Sergey 
> 
> On Mon, Jun 19, 2017 at 11:28 AM, Batyrshin Alexander <0x62ash@gmail.com <mailto:0x62ash@gmail.com>>
wrote:
> 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 <0x62ash@gmail.com <mailto:0x62ash@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
>> 
> 
> 


Mime
View raw message