You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Batyrshin Alexander <0x...@gmail.com> on 2017/06/17 00:55:20 UTC
Cant run map-reduce index builder because my view/idx is lower case
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
Re: Cant run map-reduce index builder because my view/idx is lower
case
Posted by Batyrshin Alexander <0x...@gmail.com>.
Great, i will try.
> On 23 Jun 2017, at 00:24, Sergey Soldatov <se...@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 <ma...@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 <ma...@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
>>
>
>
Re: Cant run map-reduce index builder because my view/idx is lower case
Posted by Sergey Soldatov <se...@gmail.com>.
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 <0x...@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 <0x...@gmail.com> wrote:
>
> Hello,
> Im trying to build ASYNC index by example from 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
>
>
>
Re: Cant run map-reduce index builder because my view/idx is lower
case
Posted by Batyrshin Alexander <0x...@gmail.com>.
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 <0x...@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
>