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

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

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)