[jira] [Commented] (PHOENIX-49) ArrayIndexOutOfBoundsException when creating index

["Hudson (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-49?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13925367#comment-13925367 ] 

Hudson commented on PHOENIX-49:
-------------------------------

SUCCESS: Integrated in Apache Phoenix - Branch:master #125 (See [https://builds.apache.org/job/Phoenix/125/])
PHOENIX-49 Unit test for ArrayIndexOutOfBoundsException when creating index (SaikiranPerumala) (jamestaylor: rev eb60388ef58fb0c7f17329c3b9e4912a1cbdf3e2)
* phoenix-core/src/test/java/org/apache/phoenix/index/IndexMaintainerTest.java


> ArrayIndexOutOfBoundsException when creating index
> --------------------------------------------------
>
>                 Key: PHOENIX-49
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-49
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 2.2.3
>            Reporter: Justin Workman
>            Assignee: James Taylor
>             Fix For: 3.0.0
>
>         Attachments: patch.diff
>
>
> When creating an index and you include a BIGINT column in the included data columns an ArrayIndexOutOfBoundsException is thrown. The index is created, but remains in the "BUILDING" state and never becomes active. Trying to ALTER INDEX ACTIVE results in the same ArrayIndexOutOfBounds error.
> CREATE TABLE "keywordideas" (
>         "pk" VARCHAR PRIMARY KEY,
>         "keyword"."jobId" VARCHAR,
>         "keyword"."jobName" VARCHAR,
>         "keyword"."jobType" VARCHAR,
>         "keyword"."keywordText" VARCHAR,
>         "keyword"."parentKeywordText" VARCHAR,
>         "keyword"."refinementName" VARCHAR,
>         "keyword"."refinementValue" VARCHAR,
>         "keyword"."relatedKeywordRank" DECIMAL,
>         "keyword"."searchVolume" BIGINT
>         ) IMMUTABLE_ROWS=true;
> CREATE INDEX KWD_IDX ON "keywordideas" ("jobName","parentKeywordText") INCLUDE ("keywordText","searchVolume");
> Error: java.lang.ArrayIndexOutOfBoundsException: 805104 (state=08000,code=101)
> Changing the type for searchVolume to INTEGER allows the index to be created and set active.



--
This message was sent by Atlassian JIRA
(v6.2#6252)