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

[Justin Workman (JIRA)]

Justin Workman created PHOENIX-49:
-------------------------------------

             Summary: 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


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.1.5#6160)