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

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

     [ https://issues.apache.org/jira/browse/PHOENIX-49?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maryann Xue resolved PHOENIX-49.
--------------------------------

    Resolution: Fixed

> 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)