phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3547) Promote CATALOG.VIEW_INDEX_ID to an int
Date Mon, 23 Jul 2018 19:22:00 GMT

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

ASF GitHub Bot commented on PHOENIX-3547:
-----------------------------------------

GitHub user m2je opened a pull request:

    https://github.com/apache/phoenix/pull/312

    PHOENIX-3547 Supporting more number of indices per table.

    https://issues.apache.org/jira/browse/PHOENIX-3547
    Currently the number of indices per Phoenix table is bound to maximum of 65535 (java.lang.short)
which may limit some application requiring to have arbitrary unlimited number of indices.

    This change will consider any new table created in Phoenix to support indices ids to be
in  -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 (java.lang.Long) range which is
undoubtably big enough to cover this requirement.
    Any existing Phoenix Phoenix table will still continue to support only maximum of 65535
of indices and will be able to maintain this limits as enforced before. 

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/m2je/phoenix support-large-number-of-indecies

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/phoenix/pull/312.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #312
    
----
commit 93bf44780867e313cfc3ee31c019c33e28d48e04
Author: Mahdi Salarkia <msalarkia@...>
Date:   2018-07-19T22:23:58Z

    PHOENIX-3547 Supporting more number of indecies per table.

----


> Promote CATALOG.VIEW_INDEX_ID to an int
> ---------------------------------------
>
>                 Key: PHOENIX-3547
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3547
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: Jeremy Huffman
>            Priority: Minor
>
> Increase the size of CATALOG.VIEW_INDEX_ID from smallint to int to support a large number
of indexed views on a single table.
> Per James: "The code would just need to be tolerant when reading the data if the length
is two byte short versus four byte int. At write time, we'd just always write an int."
> See: https://lists.apache.org/thread.html/22849e4fc73452cee3bea763cf6d5af7164dedcb44573ba6b9f452a2@%3Cuser.phoenix.apache.org%3E



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message